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

141 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
gummite123613(None) 
gummites1346161gummites
gemmate12418382gemmate
gimmie11298182gimmi_e
gumlike14317402gumlike
gumline102810112gumline
gummata1244612gummata
gummier12349472gummier
gumming133810192gumming
gummose1235332gummose
gunite7414402gu_nite
summate113611662summate
summit10311542summit_
summited13246392summited
summits1137972summits
ammine10314493_ammine
augite7312613au_gite
bumming143410783bumming
burkite1337003burkite
cammie124615293cammi_e
commie124215523commi_e
commit124016703commit_
commits133812373commits
commute134310423commute
crummie1336153crummi_e
cummin1288783cummi_n
cummins1358963cummins
cuprite1159683cuprite
curite85222943cu_rite
dammit11311133dammit_
dummied13346723dummied
dummies123012133dummies
dumpsite1344293dumpsite
dunite7315013du_nite
dunnite857333dunnite
eremite9312833eremite
eucrite939903eucrite
fomite113314073_fomite
fulmine1257963fulmine
fumette1245523fumette
furmity1535183furmity
gahnite1135973gahnite
gambit114714203gambit_
gambits12399723gambits
gamete9313593g_amete
gamine94620153g_amine
gammier123711193gammier
gamming133112623gamming
gemlike14206813gemlike
gemmae11507793gemm_ae
gemmated14336293gemmated
gemmates13307673gemmates
gemmier12337383gemmier
gemmily1534603gemmily
gemming13289143gemming
gemmule12173233gemmule
gemote94613023g_emote
gimme102411343gimm__e
gimmick1843273gimmick
gimmies123010113gimmies
gite55438613g___ite
gothite1146403gothite
granite82017083granite
gremmie1264383gremmi_e
grummet12298873grummet_
grummeted1552153grummeted
grummets13275033grummets
guanine8810543guanine
guide75019883gu__ide
guile64521133gu__ile
guimpe1134723guim_pe
guise64717713gu__ise
gumlines11238573gumlines
gumma105313103gumm__a
gummas114810513gumm_as
gummed123811663gumm_ed
gummer114615453gumm_er
gummers123712193gummers
gummiest13269023gummiest
gumminess1454963gumminess
gummoses1344743gummoses
gummous1236263gummous
gummy135413653gumm__y
gumshoe1343663gumshoe
gumtree1045873gumtree
gunfire1134743gunfire
gunites8313123gu_nites
gunsmith1442763gunsmith
gussie72910153gussi_e
gutlike12308653gutlike
guttate8328903guttate
guyline11258173guyline
humate113214443hu_mate
humming153310673humming
jimmie17376473jimmi_e
kunzite2053503kunzite
lucite8313343lu_cite
mammate104411273mammate
mammie94313783mammi_e
marmite112413993marmite
mite66249413___mite
mullite9313013mullite
mummied11327103mummied
mummies103812843mummies
mummify1643333mummify
mumming114010023mumming
nummulite1352153nummulite
pommie123710503pommi_e
psammite1442983psammite
pumice1238223pu_mice
pumicite1446813pumicite
quite144621463qu__ite
rummage1234583rummage
rummier11309563rummier
rummies113212793rummies
samite83020603_samite
smite75224873__smite
somite84519373_somite
submit10312673submit_
submits1139743submits
subsite9412863subsite
suite54829563su__ite
sulfite10310473sulfite
summae103911013summ_ae
summated13298833summated
summates122610483summates
summing122912383summing
summital1244703summital
summiteer1342993summiteer
summitry1543323summitry
surmise9311083surmise
tammie104212683tammi_e
termite9313893termite
tummies113012033tummies
turgite837973turgite
umpire1047893_umpire
unite54828383_u_nite
unmiter9310393_unmiter
unmitre936993_unmitre
yummier14306843yummier
yummies14359533yummies

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 Filter1786911340270.1531167915.0
2DLD Change Limit1340271416.72019944.5
3Display Results1411410.0463065.2
 (SQL Overall)1786911416.91925826.1
 
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.