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

192 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
steer5542386(None) 
seer45547041s_eer
sheer84726891sheer
sneer54919951sneer
speer74623901speer
steed66024941steed
steek95418001steek
steel55721991steel
steep76020701steep
steers63820981steers
stere55328541stere
sweer84918571sweer
ameer75618982ameer
aster55434892ast_er
beer65635992_beer
cheer105420382cheer
deer56739022_deer
deter65028042deter
emeer74815362emeer
esteem838812esteem
ester54727712est_er
ether84518772ether
fleer86020772fleer
freer86021242freer
ither84617602ither
jeer115426462_jeer
leer46239352_leer
meter75130322meter
ostler63312192ostler
other84219102other
otter54423972otter
peer66238352_peer
peter74427592peter
queer143712812queer
saber75330242saber
safer84721812safer
sager65432052sager
saker95132022saker
saner54334322saner
sateen63815012sateen
saver84831252saver
sawer85026212sawer
sayer84926552sayer
sear47353842s_ear
seder64826762seder
see35772262s_ee_
seed55549482s_eed
seeder74320772seeder
seek85935482s_eek
seeker103615362seeker
seel45042982s_eel
seem65438562s_eem
seemer84418042seemer
seen46943122s_een
seep66540342s_eep
seers55136382s_eers
sees45361052s_ees
ser36752402s__er
sere46153472s_ere
serer55935512serer
setter64023722setter
sever85426052sever
sewer84426222sewer
shear85424832shear
sheen85023312sheen
sheep105321522sheep
sheers94322402sheers
sheet84836962sheet
shewer124515112shewer
shier85428942shier
shoer84722162shoer
shyer114714782shyer
sieur5911892sieur
siker95326032siker
sitter63323382sitter
siver85728612siver
sizer145521812sizer
skee85431472skee_
skeed105018982skeed
skeen94817402skeen
skees95023122skees
skeet95429182skeet
skewer13519612skewer
skier95119592skier
sleek94619042sleek
sleep74920182sleep
sleet55639132sleet
slier54827242slier
slyer85515122slyer
smear74416392smear
smeek114912352smeek
sneers64016172sneers
sneery93610412sneery
sober74822412sober
soever94412092soever
sorer56236592sorer
sower85229312sower
spear75821062spear
speed85526622speed
speel74420762speel
speers85019952speers
speir75315362speir
spewer115112152spewer
spier75728032spier
stager74821342stager
stair54719942stair
staler64025822staler
star48037762st_ar
stare54440262stare
starer64027362starer
stater64427562stater
stayer94516482stayer
stead65520272stead
steak95219802steak
steal56125472steal
stealer72913982stealer
steam76322932steam
steamer93313092steamer
steeds73814882steeds
steeks103613702steeks
steels64117982steels
steely93612572steely
steeper93812772steeper
steeps85215192steeps
steered83615252steered
steerer73113632steerer
steeve93710902steeve
stein54620542stein
stela54019042stela
stelar64013862stelar
stele55026842stele
steles63725662steles
stem610628252st_em
stemmer113210182stemmer
stems75219952stems
steno54716862steno
stent55634512stent
step67126292st_ep
stepper113010852stepper
steps76619882steps
stereo65317912stereo
steres63929532steres
stern55319122stern
sterner7411912sterner
stet45947322st_et
stets55423912stets
stew77525462st_ew
stewed104814242stewed
stews85519142stews
stewy116112062stewy
stey76224412st_ey
stied65723032stied
sties55132982sties
stir45723252st_ir
stiver93915732stiver
stoker104417622stoker
stoner65823202stoner
stoper84320102stoper
store56333812store
storer64721672storer
stour54916742stour
stover94115642stover
streek104111412streek
streel64214022streel
street64125772street
strep77120852strep
strew89220662strew
strewer104310412strewer
stye76218972stye_
styed95815482styed
styes86316522styes
styler94013302styler
suber74924502suber
suer45334032s_uer
super74924482super
surer54833102surer
sutler63718392sutler
swear85316852swear
sweep104715722sweep
sweet85330522sweet
tear45242882_tear
tee38366872_tee_
teed55439262_teed
teel46335802_teel
teem66132602_teem
teen45938202_teen
tees45353582_tees
tier44936142_tier
tyer75323392_tyer
utter54218762utter
veer76229572_veer
weer75535092_weer

Search took 3 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 Filter178691538000.330541487.9
2DLD Change Limit538001921.82629463.3
3Display Results1921920.0633047.6
 (SQL Overall)1786911922.21980527.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.