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

127 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
summited1324639(None) 
summated13298831summated
dummied13346722dummi_ed
gummite1236132gummite_
gummites1346162gummites
mummied11327102mummi_ed
submitted1445202submitted
suited74019422su__ited
summate113611662summate_
summates122610482summates
summed114014042summ__ed
summered1338142summered
summit10311542summit__
summital1244702summital
summiteer1342992summiteer
summitry1543322summitry
summits1137972summit_s
summoned1345722summoned
surmised1136852surmised
audited939033au_dited
bummed134211723bumm__ed
committed1645713committed
commixed2264743commixed
commuted15288963commuted
dummies123012133dummi_es
fulmined1454333fulmined
gemmated14336293gemmated
grummeted1552153grummeted
gummed123811663gumm__ed
gummier12349473gummi_er
hummed144812673humm__ed
immixed1933563_immixed
jemmied19294483jemmi_ed
jimmied19275023jimmi_ed
limited102310233_limited
mummed104411553mumm__ed
mummies103812843mummi_es
mummified1643253mummified
plummeted1642163plummeted
psammite1442983psammite_
psammites1542843psammites
pumiced1435173pu_miced
pummeled1543373pummeled
quoited1756403qu_oited
rummaged1443273rummaged
rummier11309563rummi_er
rummies113212793rummi_es
samite83020603s_amite_
samites93118713s_amites
scimiter1236143scimiter
scummed14347913scumm__ed
scummier1445083scummi_er
shammied16265543shammi_ed
shimmied16294983shimmi_ed
simmered1336863simmered
sited65130743s___ited
skited114313473s__kited
slummed12359273slumm__ed
slummier1235473slummi_er
smarted105012613s_marted
smelted10399093s_melted
smiled93716433s__miled
smite75224863s__mite_
smiter83616413s__miter
smites83921923s__mites
smutted1037463s_mutted
somite84519373s_omite_
somites94219113s_omites
sopited104211053s_opited
spirited1148963spirited
spited94820443s__pited
stimied10310613stimi_ed
stummed12348553stumm__ed
stymied1335653stymi_ed
subedited1345523subedited
subitem1138543su_bitem
sublated11311493sublated
sublimed1337203sublimed
submit10312673submit__
submits1139743submit_s
submitter1345263submitter
subsided1257643subsided
subsisted1245763subsisted
subsite9412863subsite_
subsites10312763subsites
subtitled1244693subtitled
sufficed17205663sufficed
suffixed22214343suffixed
suicided1246023suicided
suite54829563su__ite_
suiter64121813su__iter
suites63727403su__ites
sulcated11310373sulcated
sulfated1238833sulfated
sulfite10310473sulfite_
sulfites1139903sulfites
sullied83714483sulli_ed
summae103911013summ_ae_
summand1236263summ_and
summarised15123913summarised
summarized24114903summarized
summer104017713summ__er
summing122912383summi_ng
summiteers1442333summiteers
summiting1445783summiting
summitries1444633summitries
summoner1245533summoner
summonsed1443303summonsed
sumpter1138873su_mpter
sumpweed1643723sumpweed
surfeited1344593surfeited
surmise9311083surmise_
surmiser1036763surmiser
surmises10310643surmises
survived1534073survived
suspired1135603suspired
tummies113012033tummi_es
umpired1235783_umpired
united74421543_u_nited
unmated103317023_unmated
unmined102612953_unmined
unmiter9310393_unmiter
unmitred1136843_unmitred
unmixed17228213_unmixed
vomited1337253_vomited
yummier14306843yummi_er
yummies14359533yummi_es

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621277.06320694.0
3Display Results1271270.0462760.9
 (SQL Overall)1786911277.26524596.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.