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

440 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
lamsters109975(None) 
hamsters13710421hamsters
lamisters1157121lamisters
lamster9109911lamster_
lasters75627691la_sters
asters65631602_a_sters
basters94930302ba_sters
blasters104116142bla_sters
casters94729892ca_sters
dabsters1137052dabsters
easters75125682ea_sters
gagsters10317072gagsters
gamesters1236732gamesters
gasters85624282ga_sters
hamster12810422hamster_
lambers113817102lam_bers
lamenters1137682lamenters
lamister1037652lamister_
lampers113817332lam_pers
lapsers93911052laps_ers
lasers64925702la_s_ers
lashers104121832la_shers
lassoers8338512lassoers
laster64830632la_ster_
leisters83312822leisters
limiters10249322limiters
listers74026522l_isters
lobsters10268732lobsters
lusters73921432l_usters
masters94628922ma_sters
pasters94531732pa_sters
plaisters1137812plaisters
plasters103518132pla_sters
rasters74629022ra_sters
scamsters1334982scamsters
seamsters1136322seamsters
tapsters10318802tapsters
tasters74225642ta_sters
teamsters1135972teamsters
waisters113811522waisters
wasters104026592wa_sters
abaters95115193_abaters
afters94717073_a_fters
alabasters1243253alabasters
alastors8311193alastors
almners9399563alm_ners
almoners1068133almoners
alters64924223_a_lters
amassers10337833_amassers
amateurs1043633_amateurs
ambeers11428923_ambeers
ambers104519563_am_bers
amblers115213563_amblers
ameers84015573_am_eers
ammeters1237693ammeters
amusers94610193_amusers
answers1037043_answers
askers105915403_a_skers
aspers86220313_a_spers
aster55434893_a_ster_
astern64815813_a_stern
austere7312993_austere
baiters94619303ba_iters
balusters1136633balusters
banisters11189473banisters
banters94623113ba_nters
barters94223033ba_rters
bashers124820833ba_shers
baster85333593ba_ster_
bastes85330383ba_ste_s
batters94626013ba_tters
bimesters1336323bimesters
bisters93922603_bisters
blamers115314213blam__ers
blaster94017303bla_ster_
blatters104414093bla_tters
blisters104015083blisters
blusters104413883blusters
boasters103915653boasters
bolsters103712443bolsters
boosters104013433boosters
bursters1038983bursters
busters94724123_busters
cadasters1236813cadasters
cambers134017433cam_bers
campers134220283cam_pers
canisters112310183canisters
canters94827723ca_nters
carters95327243ca_rters
caster85232573ca_ster_
castes85631863ca_ste_s
castors94919433ca_stors
caters85336493ca__ters
causers94014783caus_ers
clambers144211283clam_bers
clammers143510683clam_mers
clamorers1345783clamorers
clampers143211883clam_pers
clashers134213993cla_shers
claspers124410913cla_spers
classers104111833cla_ssers
clatters103313903cla_tters
cloisters1137413cloisters
clusters102912393clusters
clysters13227823clysters
coasters104317303coasters
costers94128303_costers
dabster1036703dabster_
damagers1237063damagers
dammers123214273dam_mers
damners104112113dam_ners
dampers123915693dam_pers
damsels10126703dams_els
darters84017603da_rters
dashers115016863da_shers
daters74827363da__ters
daunters9329843daunters
daystars1243903daystars
deemsters1285023deemsters
demisters1249203demisters
dempsters1435273dempsters
diameters1247583diameters
diasters92913173diasters
diesters92513593diesters
dimeters11411083dimeters
doomsters1236163doomsters
dragsters1134323dragsters
dumpsters1453743dumpsters
dusters84918353_dusters
easter65027983ea_ster_
eastern74412533ea_stern
eaters65535943ea__ters
elaters74420183ela__ters
emoters94712873_emoters
esters64627733__esters
fagoters1234853fagoters
fainters11349693fainters
falters103916473fa_lters
fastens105511753fa_stens
faster94625773fa_ster_
feasters11511563feasters
festers104121393_festers
fibsters13126403fibsters
flamers124616363flam__ers
flashers143912653fla_shers
flatters113814203fla_tters
flaunters1234503flaunters
flusters113811493flusters
fosters104220093_fosters
gagster9317633gagster_
gaiters83516533ga_iters
gambiers13337073gambiers
gamblers13369733gamblers
gamers94420823gam__ers
gamester1137323gamester_
gametes10312253gamete_s
gammers123214563gam_mers
gangsters11205733gangsters
ganisters10248313ganisters
garters84218223ga_rters
gaspers105014133ga_spers
gassers84714633ga_ssers
gaster75027353ga_ster_
gaters74728633ga__ters
glisters93912603glisters
gristers94013403gristers
gypsters1434023gypsters
hafters134614333ha_fters
halters104619803ha_lters
hamates122917673hamate_s
hammers144216053ham_mers
hampers143616943ham_pers
hastens106214813ha_stens
hastes95727073ha_ste_s
haters94930393ha__ters
hatters104221523ha_tters
haunters11329533haunters
hawsers13409483haws_ers
heisters113413133heisters
hipsters13268783hipsters
hoisters113513473hoisters
holsters113211933holsters
jammers183710703jam_mers
jaspers164310463ja_spers
jesters144118193_jesters
jousters153210403jousters
justers143815723_justers
kaisers11369273kais_ers
kamseens1442823kamseens
kashers143914023ka_shers
keesters12319593keesters
keisters123212043keisters
keysters15326333keysters
kiesters123310143kiesters
klisters123910483klisters
laagers83411253la_agers
labelers10249413labelers
laborers10208383laborers
lacers85225253la__cers
lackers134120543la_ckers
lacquers19125033lacquers
ladders94115173la_dders
laders74927763la__ders
ladlers84613563la_dlers
lagers74826143la__gers
laggers94216243la_ggers
lakers105225153la__kers
lamasery1343953lamasery
lambastes13114693lambaste_s
lamber104418493lam_ber_
lambert113617113lam_bert
lamberts12348783lam_berts
lambier113611633lambier_
lambies113015103lambie_s
lameds94812033lam__eds
lameness102612673lameness
lamenter1038863lamenter_
lamer75233703lam__er_
lames75445543lam__e_s
lampreys1542883lampreys
lancers93616643la_ncers
lanciers10308543lanciers
landers84026213la_nders
landlers94312833landlers
lanners73618323la_nners
lantern7310013la_ntern
lanterns838303la_nterns
lappers113717463la_ppers
lapser84113143laps_er_
lapses85217693laps_e_s
larders83516943la_rders
larkers113014513la_rkers
lascars979013la_scars
laser54633323la_s_er_
lases54944763la_s_e_s
lasher94824533la_sher_
lashes94831003la_she_s
lasses64827593la_sse_s
lassies74420103lassie_s
lassoer7379383lassoer_
lassoes74613853lassoe_s
lasted74323603la_ste_d
lasts57731263la_st__s
latens64620213la__tens
later54843923la__ter_
lathers104321883la_thers
lattens75014673la_ttens
latter65027893la_tter_
lattes65324203la_tte_s
lauders84012893la_uders
laughers1235923laughers
laughters1344583laughters
launders9358743launders
laveers10329363la_veers
lavers94526363la__vers
lavishers1564643lavishers
lawmakers1843893lawmakers
lawyers13377153la_wyers
layers93921183la__yers
layovers1434073layovers
leasers74717843leas_ers
leister73212753leister_
letters73819853l_etters
lifters104313773l_ifters
lighters123111373lighters
limbers113614723lim_bers
limiteds11184543limiteds
limiter92710853limiter_
limites92915453limite_s
limmers113413083lim_mers
limners93311553lim_ners
limpers113815223lim_pers
linters73822613l_inters
lispers94514323l_ispers
listees73416673l_istees
listels74212433l_istels
listens74014133l_istens
lister64527253l_ister_
liters65429873l__iters
litters73422563l_itters
loadmasters1453313loadmasters
loadstars1043303loadstars
lobster9288853lobster_
locaters102710063locaters
lofters103912903l_ofters
loiters74116613l_oiters
looters74419163l_ooters
losers65123583l_os_ers
lotters73921063l_otters
lumbers113815913lum_bers
lumpers113514483lum_pers
luster64023673l_uster_
lustres73013233l_ustres
magisters1235793magisters
maltsters1135193maltsters
mammers104615693mam_mers
mamzers20409163mam_zers
masers84623453ma_s_ers
mashers124621053ma_shers
maskers133913833ma_skers
masseters1136283masseters
master84831343ma_ster_
mastery124214323ma_stery
maters85032383__maters
matters94421753ma_tters
meisters103313843meisters
meters85625833__meters
minsters103813913minsters
misters93927503_misters
miters84328773__miters
mobsters12359053mobsters
momsers113810843moms_ers
monsters103314533monsters
munsters104010543munsters
musters94522493_musters
namers84517333nam__ers
natters73718063na_tters
nesters74422783_nesters
oaters65029783oa__ters
oldsters996733oldsters
oleasters936733oleasters
ousters74122773_ousters
oysters103411683_oysters
painters103013023painters
palmisters1444673palmisters
palters94021683pa_lters
pampers133615933pam_pers
parsers94118153pars_ers
passers94717753pa_ssers
pastels95215183pa_stels
paster85734373pa_ster_
pastern94415063pa_stern
pasterns104112623pa_sterns
pastes85233913pa_ste_s
pastors94118993pa_stors
paters84935823pa__ters
patters94825193pa_tters
pausers94113223paus_ers
paymasters1743843paymasters
pensters103012123pensters
pesters93827093_pesters
piasters102912803piasters
pilasters1138213pila_sters
placaters1336463placaters
plaister1068013plaister_
plaiters103512633pla_iters
plankters1544583plankters
planters102915323pla_nters
plashers133813453pla_shers
plaster93318693pla_ster_
plastery13279703pla_stery
platers93924083pla__ters
platters103415283pla_tters
posters93927993_posters
presters103419003presters
punsters103310583punsters
questers17168763questers
rafters103715633ra_fters
raisers73617393rais_ers
ramblers124010373ramblers
rammers113715043ram_mers
ranters73323643ra_nters
rasers64526783ra_s_ers
rashers104020903ra_shers
raspers94415913ra_spers
raster64731443ra_ster_
raters63936573ra__ters
ratters74422473ra_tters
remasters11310583remasters
resters74130403_resters
rimesters1137473rimesters
roadsters1035083roadsters
roasters83615913roasters
roisters83615543roisters
roosters83514653roosters
rosters73727533_rosters
rousters84315653rousters
roysters113610523roysters
salters73622253sa_lters
saluters8319853saluters
samites93118713samite_s
samplers12299403samplers
saunters82911743saunters
scamster1235303scamster_
seamster1037143seamster_
semesters1139113semesters
shysters14106433shysters
sisters73721573_sisters
slammers123511223slam_mers
slashers113313603sla_shers
slaters73123723sla__ters
smashers13339583smashers
smatters104011713smatters
smiters93414363_smiters
sumpters1238023sumpters
tamers84224033tam__ers
tampers113516743tam_pers
tapster9299273tapster_
tarsiers8298533tarsiers
taster64930573ta_ster_
tastes64126423ta_ste_s
taters64932193ta__ters
tatters74520483ta_tters
taunters8259263taunters
teamster1036293teamster_
tempters12257293tempters
testers74124543_testers
tipsters10278503tipsters
toasters83912703toasters
trusters83112243trusters
trysters11298363trysters
twisters11268173twisters
ulsters72711983_ulsters
unmiters1037073unmiters
vampers143111623vam_pers
vaster94521023va_ster_
vaulters11206163vaulters
vaunters11327743vaunters
vomiters1337203vomiters
wafters134112813wa_fters
waister103812383waister_
waiters104218623wa_iters
wanters104420093wa_nters
warslers11328073warslers
warstlers12284713warstlers
washers134517523wa_shers
waster95228943wa_ster_
wastery134610993wa_stery
wastes96224883wa_ste_s
waters95030623wa__ters
websters1335803websters
westers105221963_westers
wresters112711733wresters
xysters17307163_xysters
yachters1633883yachters
yammers143410323yam_mers
yatters103914623ya_tters
yawmeters1783873yawmeters
zesters163517293_zesters
zosters163015403_zosters

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.1701051123.5
2DLD Change Limit1461624407.92318447.8
3Display Results4404400.1562820.5
 (SQL Overall)1786914408.24921662.1
 
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.