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

182 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
simmered133686(None) 
shimmered1744781shimmered
simpered1338251simpered
summered1338141summered
glimmered1543102glimmered
hammered16218852hammered
immerged1444022_immerged
immersed1344832_immersed
immured1235062_immured
limbered13158122limbered
mammered12237652mammered
silvered12237562silvered
simmer104115352simmer__
simmers113314612simmer_s
simperer1237172simperer
sintered92213902sintered
sistered92612802sistered
stammered1444642stammered
swimmeret1643962swimmeret
timbered13137382timbered
yammered16225762yammered
bickered17108003bickered
bistered112913323bistered
bittered112711833bittered
bumpered1536003bumpered
cambered15129003cambered
cindered1239793cindered
ciphered1637053ciphered
commerced18125463commerced
compered153414923compered
cumbered15157963cumbered
diapered1238003diapered
dickered16117533dickered
differed1635523differed
dimmed124110323dimm__ed
dimmer114112613dimmer__
dimmers123811563dimmer_s
dithered13189293dithered
dormered1255673dormered
fibered1337643fi_bered
filtered12259043filtered
fingered13128333fingered
gibbered1444303gibbered
gimleted1243973gimleted
gingered11127743gingered
hammerer15278143hammerer
hampered16239933hampered
hindered1339453hindered
homered133212713_homered
immerge1244703_immerge
immerges1345393_immerges
immerse1145793_immerse
immerses1235953_immerses
immeshed1643433_immeshed
immixed1933573_immixed
immure1036033_immure_
immures1136713_immures
impeded13418183_impeded
inhered11313163_inhered
jiggered1834203jiggered
jimmied19275033jimm_ied
jittered16267223jittered
kippered17255623kippered
limberer12187053limberer
limmer104314793limmer__
limmers113413083limmer_s
lingered10129643lingered
lippered13287953lippered
littered92511383littered
livered113111633li_vered
lumbered13188233lumbered
membered1535903membered
mimeoed1235193mi_meoed
mitered103213233mi_tered
nickered15117023nickered
niffered1544143niffered
nimmed11368573nimm__ed
numbered13147143numbered
osiered837123osi__ered
pampered15229223pampered
pilfered1435853pilfered
pommeled1543103pommeled
pummeled1543373pummeled
reimmersed1542343reimmersed
rimmed114812303rimm__ed
rimmer103516033rimmer__
rimmers113812883rimmer_s
sabered103213023s_abered
saggered11237553saggered
scampered1635233scampered
schmeared1743053schmeared
schmeered1743273schmeered
sered65737293s___ered
severed113513863s_evered
sewered112911243s_ewered
sheered113515453s_heered
shickered19115723shickered
shimmed15338583shimm__ed
shimmer143310873shimmer__
shimmers15269413shimmer_s
shimmery18265253shimmer_y
shimmied16294983shimm_ied
shivered15177103shivered
showered1537013showered
siamese936503siamese_
siameses1036403siameses
sickened1546783sickened
sieged85212713si__eged
sieved104611443si__eved
signeted1035973signeted
silverer11216733silverer
simmering1467823simmering
simper103616293simper__
simperers1335933simperers
simpers113014123simper_s
sincere9310553sincere_
sincerer1037203sincerer
sinewed1137053si_newed
sired66134283si___red
skewered1634213skewered
skimmed16306053skimm__ed
skimmer15327533skimmer__
skimmers16296463skimmer_s
skippered1843433skippered
skittered1434633skittered
slavered12188033slavered
slimmed12368473slimm__ed
slimmer114211343slimmer__
slimmers12369633slimmer_s
slippered1434823slippered
slithered13136623slithered
slivered12218103slivered
slumbered14215593slumbered
smeared104510623s_meared
smeeked14287223s_meeked
smerked14327283s__merked
sneered83113973s_neered
snickered16115343snickered
sniggered1243443sniggered
sobered102912433s_obered
soldered1038153soldered
speered103614813s_peered
sphered133512313s_phered
spiered104412463s_piered
stamened1137633stamened
stammerer1344063stammerer
steamered1244913steamered
steered83615253s_teered
submerged1544603submerged
submersed1445863submersed
suckered1537833suckered
suffered1536733suffered
summated13298833summated
summed114014043summ__ed
summer104017713summer__
summerier1346423summerier
summerly15275103summerly
summers113616503summer_s
summerset1347253summerset
summery14329413summer_y
summited13246413summited
summoned1345723summoned
sundered10312153sundered
supered10316123s_upered
swimmer14297653swimmer__
swimmerets1751623swimmerets
swimmers15276693swimmer_s
swithered16135463swithered
syphered1755013syphered
tampered13279463tampered
tempered13248213tempered
tiered73613973ti__ered
tillered937443tillered
tinkered1387683tinkered
tittered9239493tittered
umbered121510113_umbered
whimpered20144023whimpered
wildered1336633wildered
wintered122111573wintered
withered15169433withered
yammerer15225483yammerer
zippered22244823zippered

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.1701051123.5
2DLD Change Limit1461621827.29620033.2
3Display Results1821820.0802275.0
 (SQL Overall)1786911827.54623680.2
 
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.