Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “setback” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

106 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
setback156714(None) 
seatback1675821seatback
setbacks1686301setbacks
wetback1875611wetback
cutback1747092cutback
fatback1836922fatback
outback15310652outback
retack122612822ret_ack
retrack131310722retrack
scatback1875032scatback
seatbacks17115602seatbacks
skewback1843902skewback
slotback1644202slotback
softback1944222softback
stack114421692s_t_ack
sunback1548152sunback
sweptback2252332sweptback
wetbacks1974982wetbacks
aback134816173__aback
amtrack15107393amtrack
attack12148153_attack
back125535763___back
bethank1666273bethank
buyback2045533buyback
cutbacks1845813cutbacks
cutbank1545533cutbank
debark134210943de_bark
detach12310413det_ach
detick1339383det_ick
detract101414633detract
dieback1646913dieback
embank14346553_embank
embark14458523_embark
fastback1944523fastback
fatbacks1946003fatbacks
feedback2043983feedback
fetlock1645323fetlock
finback1865823finback
hatrack1638213hatrack
hogback1945453hogback
kebbock1643613kebbock
kebbuck1642923kebbuck
outbacks1638983outbacks
outbark1339453outbark
payback2056453payback
petcock1744603petcock
reattack1444123reattack
rebeck14419913re_beck
repack142412163re_pack
rerack122513163re_rack
restack1339433restack
retacks132210713ret_acks
reteach1237413reteach
retrace91417343retrace
retracks14149103retracks
retract91318113retract
runback1556603runback
sack105337313s___ack
sawbuck1843923sawbuck
scatbacks1974713scatbacks
seabag938473seaba_g
seabags1037483seabags
seabeach1543663seabeach
seacock1545573seacock
seamark1336723seamark
seasick1346193seasick
sebacic1346393se_bacic
serac75925203se_rac_
seracs84418573se_racs
seta45637313set_a__
setae56026223set_a_e
setal56430903set_a_l
shack145321753s__hack
shellack1745083shellack
shellback2043603shellback
shtick15308013sht_ick
sidetrack1643453sidetrack
skewbacks1943513skewbacks
skyjack2242763skyjack
slack115021763s__lack
slotbacks1743863slotbacks
smack134615453s__mack
snack114718063s__nack
snapback1854423snapback
softbacks2043883softbacks
stacks124317263s_t_acks
stalk94518003s_t_alk
stank95823303s_t_ank
stark95425623s_t_ark
steak95219803s_tea_k
stick115121563s_t_ick
stock114417563s_t_ock
strick124813203s_trick
struck12489263s_truck
stuck114515773s_t_uck
subtask1335713subtask
swayback2243683swayback
sweepback2252933sweepback
tack106536293__t_ack
thack144915173__thack
tieback1547103tieback
tomback17227743tomback
track114823013__track
untack1239763unt_ack
untrack1338703untrack
zebeck23255203ze_beck

Search took 8 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911340270.1561145455.1
2DLD Change Limit1340271067.09318895.7
3Display Results1061060.0462304.3
 (SQL Overall)1786911067.29524495.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.