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

168 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
tombacs1324844(None) 
tambacs13219361tambacs
tombac12258881tombac_
tomback17227741tomback
tombacks18216461tombacks
tombaks15246861tombaks
combats13311682combats
oomiacs1135682oomiacs
tambac122210242tambac_
tambaks15218152tambaks
timbals11239532timbals
tomans85419132tom_ans
tombak14237752tomba_k
tombal102311022tomba_l
tomboys1435712tomboys
tombs97818732tomb__s
tomcats11127772tomcats
tymbals14265722tymbals
wombats1435892wombats
atomics113110853atom_ics
bombard1437333bombard
bombards1536493bombards
bombast1348223bombast
bombasts1444943bombasts
bombax1935753bomba_x
bombers134512593bombers
bombes124916823bomb_es
bombs115818823bomb__s
cognacs1256043cognacs
comas95833003com_a_s
combat12316753comba_t
combers134516623combers
combes125321733comb_es
combos125316613comb_os
combs116122963comb__s
comeback2045923comeback
comebacks2145273comebacks
comics124015563com_ics
commas124814573comma_s
compact153712213compact
compacts16368903compacts
compas125817063compa_s
compass13379563compass
corbans11313173corbans
corsacs1139013corsacs
cymbals16236143cymbals
embars103812883_embars
embays131408333_embays
gambas115817513gamba_s
gimbals12257823gimbals
gobans94412043go_bans
gombos114311093gomb_os
goombahs1642523goombahs
goombays1642823goombays
hogback1945453hogback
hogbacks2044853hogbacks
hombres14369873hombres
iambics13425643iambics
jumbals18106533jumbals
kombus1435523komb_us
limbas105313203limba_s
lumbars11289763lumbars
macs86742513__m_acs
mambas125716243mamba_s
mimbars1397383mimbars
mommas94110653momma_s
nomads94711603nom_ads
nomas74726413nom_a_s
nombles113212343nombles
numbats1137673numbats
obas65730933_o_ba_s
ombers104214403_ombers
ombres103911143_ombres
oomiac1037063oomiac_
oomiack1544223oomiack
oomiacks1643533oomiacks
oomiaks1344123oomiaks
oompahs1434263oompahs
pomace123111913pom_ace
pomaces132712123pom_aces
romans84620243rom_ans
rumbas102512013rumba_s
sambals115213483sambals
sambars115113843sambars
sambas104219263samba_s
sobas74424253so_ba_s
somans84619303som_ans
somas76030373som_a_s
stomach1436033stom_ach
stomachs1544953stom_achs
stomas84816323stom_a_s
sumacs105512103sum_acs
tamals84116633tam_als
tambak14249263tamba_k
tambala1138023tambala
tambalas1237033tambalas
tamburs11288613tamburs
tampans113310983tampans
tarmacs1138323tarmacs
tictacs1145793tictacs
tieback1547103tieback
tiebacks1646333tiebacks
timbal102510753timba_l
timbale11248803timbale
timbales12227843timbales
timbers113111853timbers
timbres11249353timbres
toads65621073to__ads
tobacco1342843to_bacco
tobaccos1442343to_baccos
tobies84521023to_bies
todays10458103to_days
toeas55726423to_ea_s
toecaps1135553toecaps
togas67823003to_ga_s
tokays13397773to_kays
tolans64319273to_lans
tolars64817943to_lars
tolas54532773to_la_s
tollbars1045443tollbars
toman75724053tom_a_n
tomato8313453tom_ato
tomb89029653tomb___
tombed113812133tomb_ed
tombing123310533tombing
tombless1236773tombless
tombola1146093tombola
tombolas1246013tombolas
tombolo1146103tombolo
tombolos1245103tombolos
tomboy1358213tomb_oy
tomcat101013453tomca_t
tomcods1234873tomcods
tomes76037383tom__es
tommies113812983tommies
toms68343493tom___s
tomtits937243tomtits
tongas74315523tonga_s
tonics83617863to_nics
toolbars1044743toolbars
topics104714583to_pics
torahs95115643to_rahs
toras55540373to_ra_s
torcs75123763to__rcs
torics85118353to_rics
tortas64918253torta_s
totals63115163to_tals
toucans937583toucans
touraco945363touraco
touracos1045313touracos
towboats1395323towboats
towsack1644723towsack
towsacks1744173towsacks
toxics153910203to_xics
triacs83913223t_riacs
tribals9610753tribals
tubas75119583t_uba_s
tumbles113816023tumbles
turbans939563turbans
tymbal13236823tymba_l
tympans14236813tympans
umiacs1035663_umiacs
womans114613653wom_ans
wombat1339863womba_t
wombs125813343womb__s
zodiacs1943423zodiacs
zombies2037993zombies
zombis1936283zomb_is

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 Limit1340271687.70317399.3
3Display Results1681680.0632666.7
 (SQL Overall)1786911687.92222556.3
 
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.