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 “steers” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

163 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
steers6382098(None) 
seers55136381s_eers
sheers94322401sheers
sneers64016171sneers
speers85019951speers
steeds73814881steeds
steeks103613701steeks
steels64117981steels
steeps85215191steeps
steer55423861steer_
steres63929531steres
ameers84015572ameers
asters65631602ast_ers
beers75628392_beers
cheers114518912cheers
deers64930522_deers
deters74724682deters
emeers83314182emeers
esteems935242esteems
esters64627732est_ers
ethers94518412ethers
fleers96015792fleers
freers94717302freers
jeers124818132_jeers
leers54828982_leers
meters85625832meters
ostlers72911202ostlers
others93918002others
otters64021512otters
peers75130272_peers
peters86624592peters
queers153510772queers
sabers85224732sabers
sakers104125432sakers
sateens73710752sateens
savers93825922savers
sawers94620162sawers
sayers94221592sayers
sears54744912s_ears
seders74420282seders
seeders83017112seeders
seeds64330062s_eeds
seekers113712332seekers
seeks94724642s_eeks
seels55632822s_eels
seemers93814332seemers
seems75525022s_eems
seeps74828752s_eeps
seer45547042s_eer_
sees45361052s_ee_s
seres55448892s_eres
sers45746652s__ers
setters73822062setters
severs94121122severs
sewers94719722sewers
shears93820902shears
sheens95116992sheens
sheer84726892sheer_
sheets93918502sheets
shewers134312052shewers
shiers94921752shiers
shoers94518332shoers
shyers124712202shyers
sieurs659042sieurs
sitters74221552sitters
sivers95324152sivers
sizers155215812sizers
skeens103912912skeens
skees95023122skee_s
skeets104513252skeets
skewers14498382skewers
skiers104713702skiers
sleeks104512462sleeks
sleeps83913322sleeps
sleets64318872sleets
smears84714432smears
smeeks12428432smeeks
sneer54919952sneer_
sneery93610412sneery
sobers85218862sobers
sowers94923442sowers
spears84019472spears
speeds94316052speeds
speels85116392speels
speer74623902speer_
speirs85013232speirs
spewers124210662spewers
spiers84421742spiers
stagers84116672stagers
stairs65416332stairs
starers74522312starers
stares66038752stares
stars55836572st_ars
staters73922342staters
stayers103813632stayers
steads74116222steads
steaks104415852steaks
stealers83412202stealers
steals64020062steals
steamers103410872steamers
steams84916902steams
steed66024942stee_d
steek95418002stee_k
steel55721992stee_l
steely93612572steely
steep76020702stee_p
steepers103011372steepers
steered83615252steered
steerer73113632steerer
steerers82511352steerers
steeve93710902steeve
steeves103410902steeves
steins64818342steins
steles63725662steles
stemmers12378442stemmers
stems75219952st_ems
stenos63915772stenos
stents65019452stents
steppers12289282steppers
steps76619882st_eps
stere55328542st_ere
stereo65317912stereo
stereos74314972stereos
stern55319122st_ern
sterns64616762sterns
stets55423912st_ets
stews85519142st_ews
sties55132982stie_s
stirs55921622st_irs
stivers103613542stivers
stokers114515182stokers
stoners74817952stoners
stopers94217372stopers
storers75018682storers
stores65533662stores
stours65015632stours
stovers103713732stovers
streeks11378712streeks
streels73811342streels
streets73312612streets
streps86218062streps
stress66616672stress
strewers11409062strewers
strews96817102strews
styes86316522stye_s
stylers10359352stylers
subers85722642subers
suers55128482s_uers
supers84622402supers
sutlers73116972sutlers
swears94114072swears
sweeps114110512sweeps
sweer84918572sweer_
sweets94214432sweets
tears55436462_tears
teels55726372_teels
teems76019782_teems
teens56227482_teens
tees45353582_tee_s
tiers55526522_tiers
tyers86220052_tyers
utters63817122utters
veers84521362_veers

Search took 4 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 Filter178691825510.360496363.9
2DLD Change Limit825511632.84329036.6
3Display Results1631630.0463543.5
 (SQL Overall)1786911633.24954998.8
 
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.