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

146 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
gummites134617(None) 
gummite1236131gummite_
dummies123012132dummi_es
gemmates13307672gemmates
gimmies123010112gimmi_es
gumlines11238572gumlines
gummier12349472gummi_er
gummiest13269032gummi_est
gumminess1454972gumminess
gummoses1344742gummoses
gunites8313122gu_nites
mummies103812842mummi_es
rummies113212792rummi_es
summates122610492summates
summited13246412summited
summits1137982summit_s
tummies113012032tummi_es
yummies14359532yummi_es
ammines11312673_ammines
augites8312183au_gites
burkites1436673burkites
cammies134016483cammi_es
commies133718453commi_es
commits133812383commit_s
commixes2177353commixes
commutes143011893commutes
crummies1437643crummi_es
cummins1358963cummi_ns
cuprites1259023cuprites
curites93919863cu_rites
dummied13346723dummi_ed
dumpsites1443763dumpsites
dunites8313593du_nites
dunnites947173dunnites
eremites10312603eremites
eucrites1049483eucrites
fomites123613203_fomites
fulmines1357783fulmines
fumettes1345773fumettes
furmities1447543furmities
gahnites1235703gahnites
gambits12399723gambit_s
gametes10312253g_ametes
gamines103618463g_amines
gammier123711193gammi_er
gammiest13339333gammi_est
gemmate12418383gemmate_
gemmated14336293gemmated
gemmier12337383gemmi_er
gemmiest13227633gemmi_est
gemminess1464643gemminess
gemmules13183213gemmules
gemotes103712143g_emotes
gimmes113010903gimm__es
gimmicks1942473gimmicks
gimmie11298183gimmi_e_
gites65630183g___ites
gothites1246013gothites
granites92116363granites
gremmies1355993gremmi_es
grummeted1552153grummeted
grummets13275033grummet_s
guanines989773guanines
guides84118283gu__ides
guiles73919283gu__iles
guimpes1245073guim_pes
guises74216313gu__ises
gullies84717313gulli_es
gumlike14317403gumlike_
gumline102810113gumline_
gummas114810513gumm__as
gummata1244613gummat_a
gummatous1442733gummatous
gummed123811663gumm__ed
gummer114615453gumm__er
gummers123712203gumm_ers
gumming133810193gummi_ng
gummose1235333gummose_
gummosis1343713gummosis
gummous1236263gumm_ous
gumshoes1444123gumshoes
gumtrees1143883gumtrees
gunfires1235063gunfires
gunite7414403gu_nite_
gunnies83413123gunni_es
gunsmiths1541633gunsmiths
guppies123310523guppi_es
gurries83515953gurri_es
gussies82813303gussi_es
guylines12236943guylines
humates122813193hu_mates
hummuses1544453hummuses
immies102412443_immi_es
immixes1835073_immixes
jammies183611293jammi_es
jemmies18318333jemmi_es
jimmies18328783jimmi_es
kunzites2143243kunzites
limites92915453_limites
lucites9311863lu_cites
lummoxes1942553lummoxes
mammies104314763mammi_es
mammitis1145593mammitis
marmites122212793marmites
mites75141803___mites
mommies103912273mommi_es
mullites10411643mullites
mummied11327103mummi_ed
mummifies1543713mummifies
nummulites1451823nummulites
pommies133712843pommi_es
psammites1542843psammites
pumices1338273pu_mices
pumicites1545623pumicites
rummages1344933rummages
rummier11309563rummi_er
rummiest12299353rummi_est
samites93118713_samites
smites83921923__smites
somites94219123_somites
submits1139753submit_s
subsites10312783subsites
suites63727403su__ites
sulfites1139903sulfites
summate113611663summate_
summated13298833summated
summit10311543summit__
summital1244703summital
summiteer1343003summiteer
summiteers1442343summiteers
summitries1444643summitries
summitry1543323summitry
surmises10310643surmises
tammies113814683tammi_es
termites10313693termites
tommies113812983tommi_es
turgites937783turgites
umpires1137813_umpires
unites65024853_u_nites
unmiter9310393_unmiter
unmiters1037073_unmiters
unmitres1036863_unmitres
unmixes16197753_unmixes
yummier14306843yummi_er
yummiest15256723yummi_est
yumminess1653643yumminess

Search took 7 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 Filter1786911461620.420425454.8
2DLD Change Limit1461621466.42322756.0
3Display Results1461460.0632317.5
 (SQL Overall)1786911466.90625874.7
 
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.