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

131 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
shimmery1826525(None) 
shimmer143310871shimmer_
shimmers15269411shimmers
shammer144613142shammer_
shammers153710842shammers
shimmed15338582shimme_d
shimmered1744782shimmered
shimmy16306412shimm__y
shinnery14305672shinnery
shivery16317022shi_very
simmer104115352s_immer_
simmers113314612s_immers
skimmer15327532skimmer_
skimmers16296462skimmers
slimmer114211342slimmer_
slimmers12369632slimmers
stemmery15334692stemmery
summery14329412s_ummery
swimmer14297652swimmer_
swimmers15276692swimmers
brimmer13348803brimmer_
brimmers14287073brimmers
chimaera1564943chimaera
chimer135517203chi_mer_
chimera14389273chi_mera
chimere144010633chi_mere
chimers144515143chi_mers
chimley1785163chimle_y
chimney1795483chimne_y
crimmer133310773crimmer_
crimmers14298543crimmers
dimmer114112613_dimmer_
dimmers123811563_dimmers
flummery1833053flummery
glimmer12437713glimmer_
glimmers13396153glimmers
grimmer123510093grimmer_
hammer138120033_hammer_
hammers144216063_hammers
hemmer134112643_hemmer_
hemmers143310843_hemmers
hummer133615273_hummer_
hummers143813063_hummers
krimmer15376873krimmer_
krimmers16315673krimmers
limmer104314793_limmer_
limmers113413083_limmers
mummery13336663_mummery
primmer134310163primmer_
rimmer103516033_rimmer_
rimmers113812883_rimmers
scammer133611973scammer_
scammers14339773scammers
scummer13398753scummer_
scummers14277783scummers
shammed153911423shamme_d
shammes144312833shamme_s
shammy16388503shamm__y
shicker163914823shicker_
shickers173012823shickers
shier85428943shi__er_
shiers94921753shi__ers
shifter132911083shifter_
shifters14319863shifters
shikker13277023shikker_
shikkers14326523shikkers
shimmering1884623shimmering
shimmied16294983shimmied
shimmies15287803shimmies
shimming16278253shimming
shiner93820873shi_ner_
shiners104015943shi_ners
shinier104113143shinier_
shinney13368293shinne_y
shipmen14317283shipme_n
shipment15217593shipment
shipper143514043shipper_
shippers153012313shippers
shirker143711343shirker_
shirkers15319583shirkers
shiver124517373shi_ver_
shivers133714833shi_vers
showery16437243sh_owery
shrimper1544413shrimper_
shrimpers1633813shrimpers
shuddery16263413shuddery
silvery13328093s_ilvery
simmered1336863s_immered
simper103616293s_imper_
simpers113014123s_impers
skimmed16306053skimme_d
skittery15315103skittery
slammer113913033slammer_
slammers123511223slammers
slimier93212013slimier_
slimmed12368473slimme_d
slimmest1235903slimmest
slippery15275863slippery
slithery14356703slithery
slumbery15296043slumbery
slummer113711203slummer_
slummers12358933slummers
smithery16325703smithery
snickery17295543snickery
spammer133410433spammer_
spammers14378693spammers
spicery14499013spi_cery
spidery13308203spi_dery
spinnery13416593spinnery
stammer116013343stammer_
stammers123611523stammers
stemmer113210183stemmer_
stemmers12378443stemmers
summary14297353s_ummary
summer104017713s_ummer_
summerly15275103s_ummerly
summers113616503s_ummers
swimmeret1643963swimmeret
swimmier15174313swimmier_
swimmily1842713swimmily
swimmy16234353swimm__y
symmetry1843553s_ymmetry
thievery1742563thievery
timbery14256893_timbery
trimmer113610833trimmer_
trimmers12288913trimmers
whimper17297723whimper_
whimpers18276613whimpers
whimsey18373893whimse_y
whiskery21314553whiskery
whispery19284293whispery

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.436409841.7
2DLD Change Limit1461621317.11020557.2
3Display Results1311310.0462847.8
 (SQL Overall)1786911317.59223536.7
 
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.