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

178 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
tomcod113578(None) 
tomcods1234871tomcods
tombed113812132tombed
tomboy1358212tomboy
tomcat101013452tomcat
tommed113310142tommed
bombed134113873bombed
boocoo1039003boocoo
coccid102910743coccid
coccoid11299283coccoid
coco87330603co_co_
cocoa98517883co_coa
cocos95624693co_cos
cod69660123___cod
combed135516543combed
combo114519433combo_
combos125316613combos
comedo11359603comedo
commode1438123commode
common12310803common
comped135919873comped
compo115318573compo_
compos124818803compos
concord12510343concord
coocoo1069693coocoo
domed95423263dom_ed
food86830573fo__od
forced126316523forced
gombo105814043gombo_
gombos114311093gombos
good66531803go__od
homed115425423hom_ed
hommos13128503hommos
homo96126473hom_o_
homos105921783hom_os
hood85132333ho__od
hotrod1048803hotrod
jomon14610083jom_on
loco67030743lo_co_
locoed94312193lo_coed
locos75822603lo_cos
mod69054403__m_od
mood76332063__mood
nimrod934873nimrod
nomad86016183nom_ad
nomoi76012533nom_oi
nomos75919743nom_os
noncom1039683noncom
poco86826153po_co_
pomo85828453pom_o_
pomos95321583pom_os
pompom1436493pompom
pompon1238943pompon
ponced114314813ponced
pood75934323po__od
ramrod936833ramrod
romeo73719703romeo_
romeos84013173romeos
romped114513653romped
rood56733003ro__od
roscoe839763roscoe
stomped124110533stomped
stood65517713sto__od
taco67031353t_aco_
tacos77023553t_acos
talced93811003talced
tamed85528513tam_ed
tamped114317043tamped
tampon102911233tampon
telco7511873telco_
telcos8710683telcos
temped113912893temped
tempo95214973tempo_
tempos103812293tempos
ticced11438443ticced
timed85223613tim_ed
timid84815733tim_id
toad55830183to__ad
tod49457073t___od
toecap1037323toecap
toed56137043to__ed
toehold1146573toehold
togaed84711343togaed
togged95117513togged
toiled74420323toiled
toited74016753toited
toked105626493to_ked
told56132203to__ld
toled65934923to_led
toledo7419993toledo
tolled73819033tolled
toluid738213toluid
toluol636903toluol
tom514358053tom___
toman75724053tom_an
tomans85419133tomans
tomato8313453tomato
tomb89029653tom__b
tombac12258883tombac
tombak14237753tombak
tombal102311023tombal
tombola1146103tombola
tombolo1146103tombolo
tomboys1435713tomboys
tombs97818733tom_bs
tomcats11127773tomcats
tome67543193tom__e
tomes76037383tom_es
tomfool1254243tomfool
tommy124712233tom_my
tompion11247103tompion
toms68343493tom__s
tomtit8413853tomtit
tondo69718683tondo_
tondos75115923tondos
toned65435343to_ned
tonged86518903tonged
too38965423to__o_
took86531073to__ok
tool46735683to__ol
tooled74918903tooled
toom66532933to__om
toon47740633to__on
toot45958883to__ot
tooted74620123tooted
topcoat1179313topcoat
toped85631313to_ped
topo66932403to_po_
topoi76018353to_poi
topos75726393to_pos
topped114617723topped
torc66333353torc__
torch107420933torc_h
torched133511353torched
torchon1237363torchon
torchy14549533torchy
torcs75123763torc_s
toro48045683to_ro_
toroid7416013toroid
toros54336193to_ros
torot56139943to_rot
torpid9310913torpid
torpor839193torpor
torrid7311853torrid
torso56922143torso_
torsos64815733torsos
tossed74215223tossed
toted64929483to_ted
totted74319953totted
toucan838193toucan
touch106519393touc_h
touche114916173touche
touched134914963touched
touchy145010503touchy
toured74216153toured
toused74122013toused
touted74419743touted
toward10311063toward
towed95134583to_wed
towmond1394203towmond
toxoid1438153toxoid
toyed96019803to_yed
toyo76925453to_yo_
toyon86715673to_yon
toyos87519143to_yos
traced94821583traced
triced95518673triced
tricot8317753tricot
tripod9399853tripod
trod57627953t__rod
tromped124210293tromped
truced95312053truced
tumid84114023tum_id
tumor71110693tum_or
tumped114216233tumped
voiced123910113voiced
wombed14419233wombed
wood85329383wo__od

Search took 6 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 Filter1786911127160.373479064.3
2DLD Change Limit1127161785.40620850.2
3Display Results1781780.0632825.4
 (SQL Overall)1786911785.84230587.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.