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

199 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
lamister103765(None) 
lamisters1157121lamisters
lamster9109911lam_ster
banister10199972banister
canister101710852canister
demister11310222demister
gamester1137322gamester
ganister9178992ganister
hamster12810422ham_ster
lamenter1038862lamenter
lamsters1099752lam_sters
laster64830632la__ster
lavisher1445082lavisher
leister73212752l_eister
limiter92710852limi_ter
lister64527252l__ister
magister1136282magister
mister84728562__mister
palmister1345052palmister
plaister1068012pla_ister
waister103812382wa_ister
admitter1135113admitter
agisted938203_agisted
alabaster1143353alabaster
amasser9418733_amasser
ammeter1148393_ammeter
amuser84712623_amus_er
assister836743assister
aster55434893_a__ster
baiter84422553ba_i_ter
baluster1037053baluster
banisher13169183banisher
banisters11189473banisters
bannister1155373bannister
barrister1145733barrister
baster85333593ba__ster
batiste939743batiste_
batistes1039713batistes
bemisted1368383bemisted
bimester1236163bimester
bister84922763__bister
blaster94017303bla__ster
blemisher1663653blemisher
blister94415313_blister
cadaster1136893cadaster
camise103319633camis_e_
camises114218463camis_es
canistel10187253canistel
canisters112310183canisters
cannister1155723cannister
caster85232573ca__ster
cloister1037093cloister
dabster1036703da_bster
demisters1249203demisters
dempster1355773dempster
dumpster1344053dumpster
easter65027983ea__ster
emitter93211083_emitter
enlister847803enlister
fainter103611053fa_inter
famished1766023famished
famishes1658283famishes
faster94625773fa__ster
filister1137403filister
flamier123112143flami__er
gagster9317633ga_gster
gaiter73819503ga_i_ter
gamesters1236733gamesters
gamier93617933gami__er
gangster10215773gangster
ganisters10248313ganisters
gannister1054173gannister
gaster75027353ga__ster
glister84013343_glister
grister83915413_grister
hamsters13710423ham_sters
heister103613623_heister
hemipter1545583hemipter
hoister103714203_hoister
insister888783insister
kaiser103610373ka_is_er
keister113011573_keister
klister113410643_klister
labiate91313573labiate_
labiated11109303labiated
labiates101011513labiates
lacier84020093laci__er
lakier104716273laki__er
lamasery1343953lamas_ery
lambaste12145013lambaste_
lambasted14103253lambasted
lambastes13114693lambastes
lamber104418493lam__ber
lambier113611633lam_bier
lamented1138193lamented
lamenters1137683lamenters
lamer75233703lam___er
lamest84722763lamest__
lamiae84817453lami_ae_
laminae93512973laminae_
laminar93810283lami_nar
laminate103014633laminate_
laminated122610283laminated
laminates112712903laminates
laminator1147553laminator
lapises93513463lapis_es
lapser84113143la_ps_er
lariated91212063lariated
laser54633323la__s_er
lasher94824533la__sher
lassoer7379383la_ssoer
lasted74323603la__sted
lasters75627693la__sters
later54843923la___ter
latter65027893la__tter
laughter1245113laughter
lavished1555133lavished
lavishers1564643lavishers
lavishes1457403lavishes
lazier154214613lazi__er
leisters83312823l_eisters
lifter93814813l__ifter
limier83518713limi__er
limited102310233limi_ted
limiters10249323limi_ters
limites92915453limi_tes
limpsier1234433limpsier
linter64625333l__inter
lisper84114433l__isper
listed74322833l__isted
listee64223063l__istee
listel64214733l__istel
listen64816813l__isten
listers74026523l__isters
liter54736343l__i_ter
litter64324853l__itter
loadmaster1343233loadmaster
loamier9349163loami__er
lobster9288853l_obster
loiter64619173l_oi_ter
luster64023673l__uster
magisters1235793magisters
maltster1035303maltster
master84831343__master
meister93114163_meister
milter84921233__milter
minister10410363minister
minster93914323__minster
minter84425103__minter
miser75430403__mis_er
misted93625823__misted
misterm114314513__misterm
misters93927503__misters
mistier93418713__mistier
miter75734793__mi_ter
moister94015373_moister
muster84724523__muster
omitter9298503_omitter
painter93814563pa_inter
palmisters1444673palmisters
paster85734373pa__ster
paviser12489093pavis_er
paymaster1643873paymaster
plaisters1137813pla_isters
plaiter93615393pla_i_ter
planisher1495853planisher
plaster93318693pla__ster
raiser66620103ra_is_er
raster64731443ra__ster
ravisher1465453ravisher
register939553register
remaster10311473remaster
remitter102810323remitter
resister8311653resister
rimester1037813rimester
roister73516203_roister
samisen937673samis_en
samite83020603sami_te_
samites93118713sami_tes
scamster1235303scam_ster
seamster1037143seam_ster
semester1038903semester
sinister838583sinister
sister64421583__sister
smiter83616413_smi_ter
tamises92715973tamis_es
tapster9299273ta_pster
taster64930573ta__ster
teamster1036293team_ster
twister10308953_twister
unmiter9310393unmi_ter
vanisher14167453vanisher
varistor1146383varistor
vaster94521023va__ster
vomiter1237953vomi_ter
waisted114210943wa_isted
waisters113811523wa_isters
waiter94321253wa_i_ter
waster95228943wa__ster

Search took 9 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.200893455.0
2DLD Change Limit1461621997.76618820.8
3Display Results1991990.0802487.5
 (SQL Overall)1786911998.04622208.7
 
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.