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

130 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
sheep10532152(None) 
cheep125416501cheep
seep66540341s_eep
sheen85023311sheen
sheer84726891sheer
sheet84836951sheet
shlep104914831shlep
sleep74920181sleep
steep76020701steep
sweep104715721sweep
wheep136214351wheep
asleep847282asleep
beep85931212_beep
bleep95013452bleep
cheap126915942cheap
cheek145115712cheek
cheeps135312912cheeps
cheer105420382cheer
creep95218102creep
deep76031882_deep
ghee85726112ghee_
ghees95215552ghees
heap96432892_heap
heed86437602_heed
heel75034222_heel
help95328922_help
hemp115725622_hemp
hep86644142_h_ep
jeep135624842_jeep
keep106329812_keep
kreep114610412kreep
neep65728312_neep
peep85833692_peep
salep77022952salep
schlep1347092schlep
see35772262s_ee_
seed55549482s_eed
seek85935482s_eek
seel45042982s_eel
seem65438562s_eem
seen46943122s_een
seeps74828752s_eeps
seepy104717972s_eepy
seer45547042s_eer
sees45361052s_ees
shape105125112shape
sharp104922532sharp
she66837692sh_e_
shea76031572sh_ea
sheaf115424122sheaf
sheal84927702sheal
shear85424832shear
sheas86331792sheas
shed86536152sh_ed
sheds96122702sheds
sheens95116992sheens
sheeny124912192sheeny
sheers94322402sheers
sheesh1237812sheesh
sheets93918492sheets
sheeve123412842sheeve
sheik122514652sheik
shekel1338382shekel
shelf115221112shelf
shell84424122shell
shend94719972shend
shent85933492shent
sheol84318362sheol
sheqel1846522sheqel
sherd96321152sherd
sherpa1138092sherpa
shes75734352sh_es
shew108030762sh_ew
shewed134716182shewed
shewer124515102shewer
shewn115715702shewn
shews115924712shews
shied96125492shied
shiel811023772shiel
shier85428942shier
shies86136552shies
ship95228232sh_ip
shlepp13366192shlepp
shleps114710332shleps
shoe75933432shoe_
shoed95723002shoed
shoer84722152shoer
shoes85429652shoes
shop95629832sh_op
shred98125612shred
shrew119720162shrew
shyer114714782shyer
skee85431472skee_
skeed105018982skeed
skeen94817402skeen
skees95023122skees
skeet95429182skeet
skelp114211422skelp
skep105219352s_kep
sleek94619042sleek
sleeps83913322sleeps
sleepy11479412sleepy
sleet55639132sleet
smeek114912352smeek
sneap75514822sneap
sneer54919952sneer
speed85526622speed
speel74420762speel
speer74623902speer
steed66024942steed
steek95418002steek
steel55721992steel
steeps85215192steeps
steer55423862steer
step67126292s_tep
strep77120852strep
sweeps114110512sweeps
sweepy14447452sweepy
sweer84918572sweer
sweet85330522sweet
thee78039062thee_
thesp105410312thesp
threep115910112threep
veep95325092_veep
weep95131652_weep
whee105429592whee_
wheel115515332wheel
wheen115016052wheen
wheeps14439952wheeps
whelp136012092whelp

Search took 2 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 Limit538001301.72031279.1
3Display Results1301300.0304333.3
 (SQL Overall)1786911301.84396956.6
 
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.