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 “tomback” 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.

109 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
tomback1722774(None) 
tombac12258881tombac_
tombacks18216461tombacks
tombacs13248441tombacs
tombak14237751tomba_k
comeback2045922comeback
hogback1945452hogback
oomiack1544222oomiack
tambac122210242tambac_
tambacs13219362tambacs
tambak14249262tamba_k
tieback1547102tieback
tombaks15246862tombaks
tombal102311022tomba_l
towsack1644722towsack
aback134816173__aback
back125535763___back
blowback2143993blowback
bombard1437333bombard
bombast1348223bombast
bombax1935753bomba_x
buyback2045533buyback
combat12316753comba_t
combats13311683combats
comebacks2145273comebacks
compact153712213compact
cossack1545823cossack
cutback1747093cutback
dieback1646913dieback
embank14346553_embank
embark14458523_embark
fatback1836923fatback
finback1865823finback
hogbacks2044853hogbacks
holdback2044513holdback
hommock2043993hommock
hopsack1845273hopsack
humpback2343593humpback
imbark14347863_imbark
jumbuck2443273jumbuck
limbeck1744173limbeck
mack125733653__m_ack
mossback1843713mossback
nonbank1345903nonbank
nonblack1644303nonblack
oomiac1037063oomiac_
oomiacks1643533oomiacks
oomiacs1135683oomiacs
oomiak1235353oomia_k
outback15310653outback
payback2056453payback
plowback2143303plowback
pollack1567333pollack
pomace123111913pom_ace
roebuck1544603roebuck
rollback1644883rollback
roorback1654813roorback
runback1556603runback
setback1567143setback
slotback1644203slotback
smack134615453_sm_ack
softback1944223softback
stomach1436033stom_ach
stopbank1643453stopbank
sunback1548153sunback
tack106536293t___ack
tailback1644923tailback
talkback1543933talkback
tamarack1644363tamarack
tambaks15218153tambaks
tambala1138023tambala
tanbark1337373tanbark
thack144915173t__hack
thornback20162553thornback
throwback231934833throwback
thumbtack2251513thumbtack
thwack1834213t_hwack
tiebacks1646333tiebacks
timbal102510753timba_l
timbale11248803timbale
timbals11239533timbals
tobacco1342843to_bacco
tomahawk2051743tomahawk
toman75724053tom_a_n
tomans85419133tom_ans
tomato8313453tom_ato
tomb89029653tomb___
tombed113812133tomb_ed
tombing123310533tombing
tomblike1645143tomblike
tombola1146103tombola
tombolo1146103tombolo
tomboy1358213tomb_oy
tomboys1435713tomboys
tombs97818733tomb__s
tomcat101013453tomca_t
tomcats11127773tomcats
topkick1443143topkick
touchback22163013touchback
touraco945363touraco
towsacks1744173towsacks
track114823013t__rack
tripack1565673tripack
tymbal13236823tymba_l
tymbals14265723tymbals
umiack1435173_umiack
wetback1875613wetback
wombat1339863womba_t
wombats1435893wombats

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.423422437.4
2DLD Change Limit1340271096.87319500.5
3Display Results1091090.0462369.6
 (SQL Overall)1786911097.34224338.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.