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

106 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
simmer10411535(None) 
dimmer114112611dimmer
limmer104314791limmer
rimmer103516031rimmer
shimmer143310871shimmer
simmers113314611simmers
simper103616291simper
skimmer15327531skimmer
slimmer114211341slimmer
summer104017711summer
swimmer14297651swimmer
aimer75926822ai_mer
brimmer13348802brimmer
bummer124014102bummer
crimmer133310772crimmer
cummer124414592cummer
dammer114317932dammer
dimer85625602di_mer
dimmed124110322dimmed
dimmers123811562dimmers
emmer94314462_emmer
filmer114112402filmer
firmer114712442firmer
gammer1112318332gammer
gimme102411342gimme_
gimmes113010902gimmes
glimmer12437712glimmer
grimmer123510092grimmer
gummer114615452gummer
hammer138120032hammer
hemmer134112642hemmer
hummer133615272hummer
isomer8310152isomer
jammer174014132jammer
jimper17389862jimper
krimmer15376872krimmer
limber104316792limber
limier83518722limier
limmers113413082limmers
limner84112872limner
limper104117852limper
mammer94218862mammer
mimer94825762mi_mer
mummer93614542mummer
nimmed11368572nimmed
primmer134310162primmer
rammer103519652rammer
rimer75429242ri_mer
rimier83916272rimier
rimmed114812302rimmed
rimmers113812882rimmers
rummer104715482rummer
scammer133611972scammer
scummer13398752scummer
seamer84223612seamer
seemer84418042seemer
shammer144613142shammer
shimmed15338582shimmed
shimmers15269412shimmers
shimmery18265252shimmery
sicker124023902sicker
sidler74716962sidler
sifter94516232sifter
sigher103813702sigher
signer74015632signer
siker95326032si_ker
siller64026062siller
silver93815812silver
simar74920812si_mar
simmered1336862simmered
simnel857022simnel
simpers113014122simpers
simpler112910862simpler
singer74227312singer
sinker103620902sinker
sinner64320602sinner
sinter63625922sinter
sipper103920992sipper
sister64421582sister
sitter63323382sitter
siver85728612si_ver
sizer145521812si_zer
sizier1514813392sizier
skimmed16306052skimmed
skimmers16296462skimmers
slammer113913032slammer
slimier93212012slimier
slimmed12368472slimmed
slimmers12369632slimmers
slummer113711202slummer
smiler83916682smiler
smiter83616412smiter
somber103714002somber
spammer133410432spammer
stammer116013342stammer
stemmer113210182stemmer
summed114014042summed
summers113616502summers
summery14329412summery
swimmers15276692swimmers
swimmier15174312swimmier
timber104012682timber
timer75626042ti_mer
trimmer113610832trimmer
tsimmes1133672tsimmes
yammer133713182yammer

Search took 3 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.330541487.9
2DLD Change Limit825511062.58031996.5
3Display Results1061060.0303533.3
 (SQL Overall)1786911062.94060779.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.