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 “summer” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

111 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
summer10401771(None) 
bummer124014101bummer
cummer124414591cummer
gummer114615451gummer
hummer133615271hummer
mummer93614541mummer
rummer104715481rummer
scummer13398751scummer
simmer104115351simmer
slummer113711201slummer
summed114014041summed
summers113616501summers
summery14329411summery
bummed134211722bummed
bummers133712442bummers
bumper123714342bumper
cumber124016702cumber
cummers133713472cummers
dammer114317932dammer
dimmer114112612dimmer
drummer12407502drummer
dumber114414172dumber
dumper114615212dumper
emmer94314462_emmer
fumer105918232fu_mer
fumier11310902fumier
gammer1112318332gammer
glummer12417982glummer
grummer12338782grummer
gummed123811662gummed
gummers123712192gummers
gummier12349472gummier
hammer138120032hammer
hemmer134112642hemmer
hummed144812672hummed
hummers143813062hummers
humper134115882humper
jammer174014132jammer
jumper173612372jumper
kummel14266172kummel
limmer104314792limmer
lumber103817772lumber
lumper103816652lumper
mammer94218862mammer
mummed104411552mummed
mummers103712842mummers
mummery13336662mummery
mumper123513522mumper
number103913222number
plummer13298522plummer
pummel12278042pummel
pumper124415552pumper
rammer103519652rammer
rimmer103516032rimmer
rummers113513652rummers
rummier11309562rummier
scammer133611972scammer
scummed14347912scummed
scummers14277782scummers
scummier1445082scummier
seamer84223612seamer
seemer84418042seemer
shammer144613142shammer
shimmer143310872shimmer
simmers113314612simmers
simper103616292simper
skimmer15327532skimmer
slammer113913032slammer
slimmer114211342slimmer
slumber113811002slumber
slummed12359272slummed
slummers12358932slummers
slummier1235472slummier
somber103713992somber
spammer133410432spammer
spumier1137902spumier
stammer116013342stammer
stemmer113210182stemmer
strummer1234782strummer
stummed12348552stummed
stumper113610092stumper
suaver93014232suaver
suber74924502su_ber
sucker124120662sucker
sudser73511282sudser
suer45334032su__er
suffer124314512suffer
suiter64121812suiter
sulker104015922sulker
summa94713312summ_a
summae103911012summae
summary14297352summary
summas104313162summas
summered1338142summered
summerly15275092summerly
summit10311542summit
summon1037622summon
summoner1245532summoner
sumpter1138872sumpter
sunder74019822sunder
super74924482su_per
supper104115432supper
surer54833092su_rer
surfer93515882surfer
surger74320092surger
sutler63718392sutler
swimmer14297652swimmer
tummler11266612tummler
umber94617582_umber
yammer133713182yammer
yummier14306842yummier

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 Filter178691825510.1431249587.4
2DLD Change Limit825511115.64014636.7
3Display Results1111110.0303700.0
 (SQL Overall)1786911115.81330739.9
 
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.