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

269 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
studiers923662(None) 
studier82510051studier_
studies82413861studie_s
sauciers1076732sauciers
shudders13316642shudders
soldiers9277772soldiers
spudders12255632spudders
steadiers1035082steadiers
striders94412122striders
studdies10207072studdie_s
studied9268692studie_d
studios8256642studi_os
studious9245552studious
studlier935472studlier_
stuffers14277382stuffers
stuivers11406672stuivers
stumpers12318312stumpers
stunners8277922stunners
sturdier9216962sturdier_
sturdies92110272sturdie_s
stutters83210472stutters
sudsers83310422s_udsers
tidiers8389772_tidiers
ateliers837883ateliers
bludgers12397853bludgers
bouviers1375003bouviers
budders113812103_budders
budgers114314923_budgers
buriers94017193_buriers
chudders15235563chudders
costumiers1442973costumiers
couriers103213173couriers
drudgers11326853drudgers
eluders8409903elud_ers
etudes73811603etud_e_s
gaudier938453gaudier_
gaudies9311973gaudie_s
grudgers11266753grudgers
guiders94111113_guiders
hauliers1176713hauliers
judders16347793_judders
judgers16369043_judgers
lauders84012893laud_ers
luthiers1135163luthiers
mudders113211113_mudders
nudgers9479373_nudgers
nudies75217093_nudie_s
outdoers937513outdoers
outliers82610673outliers
puttiers10288013puttiers
restudies10156033restudie_s
roturiers944553roturiers
rudders93210653_rudders
saddlers10289753saddlers
salliers83613343salliers
saltiers83411953saltiers
sanders84025943sand_ers
sandier84017843sandier_
saucers93712133sau_cers
saucier9810283saucier_
saugers83914053sau_gers
saunters82911753saunters
sauries72821623saurie_s
scuffers16307493scuffers
sculkers14306933sculkers
scullers103510483scullers
scummers14277783scummers
scunners10357303scunners
scuppers1446543scuppers
scutters103311023scutters
seders74420283s_ed_ers
seducers1145383seducers
seeders83017113seed_ers
seedier83513633seedier_
senders83022353send_ers
shaders115915553shad_ers
shadier113111153shadier_
shedders13267433shedders
shiers94921753s__hiers
shuckers17388133shuckers
shudder12297323shudder_
shuddery16263413shuddery
shunners11317743shunners
shunters113210753shunters
shushers14267053shushers
shutters113611353shutters
sidlers83414233s_idlers
skidders1454823skidders
skiers104713703s__kiers
skulkers11334923skulkers
skydivers2051383skydivers
sledders10257373sledders
sliders83515223slid_ers
slubbers12349943slubbers
sludges93811993sludge_s
sludgier1034823sludgier_
sluggers10348483sluggers
slumbers123110273slumbers
slummers12358933slummers
smudges11348283smudge_s
smudgier1233753smudgier_
snubbers12326673snubbers
snuffers14326923snuffers
soddies92312853soddie_s
solders83517773sold_ers
soldier82812153soldier_
soldiery12254613soldiery
sonders83820713sond_ers
sounders93214113sounders
soupier93111753soupier_
souters74422603sou_ters
southers114214453southers
spaders104214473spad_ers
spiders103914413spid_ers
spiers84421743s__piers
spudder11256553spudder_
spumier1137903spumier_
spurners10288493spurners
spurrers10338463spurrers
spurriers11245063spurriers
spurters103311703spurters
sputters104012873sputters
squarers17338023squarers
squires163812843squ_ires
stabbers12268733stabbers
stablers103611153stablers
stackers143413563stackers
stades74626243stad_e_s
stadias8411113stadi_as
stadiums1145703stadiums
staffers14247083staffers
stagers84116673st_agers
staggers10379843staggers
stagier83513443stagier_
staider83912613staider_
stainers83212173stainers
stairs65416333st_ai_rs
stalkers12369853stalkers
stammers123611523stammers
stampers124211603stampers
standers93514303standers
staplers103111203staplers
starers74522313st_arers
starkers123712393starkers
starters83714773starters
starvers11459643starvers
staters73922343st_aters
stayers103813633st_ayers
steadier937313steadier_
steadies9311123steadie_s
stealers83412203stealers
steamers103410873steamers
steepers103011373steepers
steerers82511353steerers
steers63820983st__eers
stemmers12378443stemmers
steppers12289283steppers
stickers142913033stickers
sties55132983st__ie_s
stiflers11238833stiflers
stimies9316563stimie_s
stingers94012743stingers
stinkers123111133stinkers
stinters83312753stinters
stirrers8266943stirrers
stirs55921623st__i_rs
stivers103613543st_ivers
stockers143411073stockers
stodges9309083stodge_s
stodgier1034223stodgier_
stogies8413693stogie_s
stokers114515183st_okers
stompers123610043stompers
stoners74817953st_oners
stonier72013793stonier_
stookers12449793stookers
stoopers103711303stoopers
stopers94217373st_opers
stoppers123910593stoppers
storers75018683st_orers
stories7324273storie_s
stovers103713733st_overs
strafers11379913strafers
strainers9510383strainers
strayers113510143strayers
strewers11409053strewers
strider84315723strider_
strides84520393stride_s
stridors9367313stridors
strikers123611293strikers
stripers103911593stripers
strivers113911843strivers
strokers123910903strokers
stroyers11388923stroyers
strudels934123strud_els
strummers1333693strummers
strutters955693strutters
stubbier1235353stubbier_
stuccoers1342563stuccoers
studded10236873studde_d
studdie9195273studdie__
studdings1242933studdings
student848343stud_ent
students954683students
studhorse1342033studhorse
studiedly1441993studiedly
studio7247133studi__o
studliest1036573studliest
studs64415873stud___s
studwork1643683studwork
studworks1743673studworks
stuffer13349793stuffer_
stuffier14336623stuffier_
stuiver10447083stuiver_
stumblers1334383stumblers
stumper113610093stumper_
stumpier1255883stumpier_
stunner7349193stunner_
stupefiers1552003stupefiers
stupes84116953stu_pe_s
stupider1133913stupider_
stupids1035273stupi_ds
stupors935883stu_pors
sturdied10215963sturdie_d
sturdiest10207393sturdiest
sturdiness1144843sturdiness
stutter72911463stutter_
stylers10359353st_ylers
stylisers12204243stylisers
stylizers21194333stylizers
stymies1239213stymie_s
subduers1186363subduers
subers85722643s_u_bers
suckers133717623s_uckers
suddens9308783s_uddens
sudors7311103s_ud_ors
sudser73511283s_udser_
sudses74114503s_udse_s
sudsier868783s_udsier_
suers55128483s_u__ers
suffers133113543s_uffers
suiters73618883s_uiters
sulkers113613343s_ulkers
summers113616503s_ummers
sunders84120053s_unders
supers84622403s_u_pers
suppers113314703s_uppers
surfers103614133s_urfers
surgers83517483s_urgers
sutlers73116973s_utlers
tedders94010233_tedders
tidier73515113_tidier_
tidies74721833_tidie_s
tiers55526523_t__iers
todies74223553_todie_s
triers64321523_t_riers
trudgers10256863trudgers
tubbers113411253_tubbers
tubers85017033_tu_bers
tuckers134014353_tuckers
tufters10298353_tufters
tuggers93711443_tuggers
tuners64417343_tu_ners
turners73912893_turners
tuskers113710043_tuskers
tussers74313563_tussers
tuyers94612563_tu_yers
twiers95410163_t_wiers
udders83911293__udders

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.406440125.6
2DLD Change Limit1461622696.75021653.6
3Display Results2692690.0932892.5
 (SQL Overall)1786912697.24924650.4
 
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.