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

132 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
steep7602070(None) 
seep66540341s_eep
sheep105321521sheep
sleep74920181sleep
steed66024941steed
steek95418001steek
steel55721991steel
steeps85215191steeps
steer55423861steer
step67126291st_ep
strep77120851strep
sweep104715721sweep
asleep847282asleep
beep85931212_beep
bleep95013452bleep
cheep125416502cheep
creep95218102creep
deep76031882_deep
esteem838812esteem
jeep135624842_jeep
keep106329812_keep
kreep114610412kreep
neep65728312_neep
peep85833692_peep
salep77022952salep
sateen63815012sateen
see35772262s_ee_
seed55549482s_eed
seek85935482s_eek
seel45042982s_eel
seem65438562s_eem
seen46943122s_een
seeps74828752s_eeps
seepy104717972s_eepy
seer45547042s_eer
sees45361052s_ees
setup73915822setup
sheen85023312sheen
sheer84726892sheer
sheet84836952sheet
shlep104914832shlep
skee85431472skee_
skeed105018982skeed
skeen94817402skeen
skees95023122skees
skeet95429182skeet
skelp114211422skelp
skep105219352s_kep
sleek94619042sleek
sleeps83913322sleeps
sleepy11479412sleepy
sleet55639132sleet
smeek114912352smeek
sneap75514822sneap
sneer54919952sneer
speed85526622speed
speel74420762speel
speer74623902speer
stamp95217362stamp
stead65520272stead
steak95219802steak
steal56125472steal
steam76322922steam
steeds73814882steeds
steeks103613702steeks
steels64117982steels
steely93612572steely
steeped103412282steeped
steepen9348652steepen
steeper93812772steeper
steeple937322steeple
steeply1236292steeply
steers63820982steers
steeve93710902steeve
stein54620532stein
stela54019042stela
stele55026842stele
steles63725662steles
stem610628242st_em
stems75219952stems
steno54716862steno
stent55634512stent
steppe10319872steppe
steps76619882steps
stere55328542stere
stereo65317912stereo
steres63929532steres
stern55319122stern
stet45947322st_et
stets55423912stets
stew77525462st_ew
stewed104814242stewed
stews85519142stews
stewy116112062stewy
stey76224412st_ey
stied65723032stied
sties55132982sties
stipe76523372stipe
stirp76815502stirp
stomp95616662stomp
stoop75821542stoop
stop66532032st_op
stope74727242stope
stoup75517072stoup
stowp105614232stowp
strap77925262strap
streek104111412streek
streel64214022streel
street64125772street
streps86218062streps
strew89220652strew
strip77524332strip
strop77422242strop
stump94616462stump
stupe75217752stupe
stye76218972stye_
styed95815482styed
styes86316522styes
sweeps114110512sweeps
sweepy14447452sweepy
sweer84918572sweer
sweet85330522sweet
tee38366872_tee_
teed55439262_teed
teel46335802_teel
teem66132602_teem
teen45938202_teen
tees45353582_tees
temp85323332_temp
veep95325092_veep
weep95131652_weep
wheep136214352wheep

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.0931921408.6
2DLD Change Limit538001321.89328420.5
3Display Results1321320.0304400.0
 (SQL Overall)1786911322.01688636.4
 
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.