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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

98 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
sweep10471572(None) 
seep66540341s_eep
sheep105321521sheep
sleep74920181sleep
steep76020701steep
sweeps114110511sweeps
sweepy14447451sweepy
sweer84918571sweer
sweet85330521sweet
weep95131651_weep
asleep847282asleep
awee76336642awee_
beep85931212_beep
beweep13147252beweep
bleep95013452bleep
cheep125416502cheep
creep95218102creep
deep76031882_deep
dweeb1137742dweeb
jeep135624842_jeep
keep106329812_keep
kreep114610412kreep
neep65728312_neep
peep85833692_peep
salep77022952salep
see35772262s_ee_
seed55549482s_eed
seek85935482s_eek
seel45042982s_eel
seem65438562s_eem
seen46943122s_een
seeps74828752s_eeps
seepy104717972s_eepy
seer45547042s_eer
sees45361052s_ees
sewed95325162sewed
sewer84426212sewer
sheen85023312sheen
sheer84726892sheer
sheet84836962sheet
shlep104914832shlep
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
swamp125015322swamp
swap95925432sw_ap
swear85316852swear
sweat85628402sweat
swede94413202swede
swedes102711892swedes
sweeny12358842sweeny
sweeper12329372sweeper
sweets94214432sweets
swell84815982swell
swept105720602swept
sweven1235982sweven
swipe105217082swipe
swoop105213432swoop
swop95120502sw_op
twee76827082twee_
tweed94915092tweed
tween84413742tween
tweet84823982tweet
twerp10398412twerp
upsweep1442572upsweep
veep95325092_veep
wee66760812_wee_
weed85637512_weed
week116428152_week
weel75834082_weel
ween75835462_ween
weeps104120562_weeps
weepy134212592_weepy
weer75535092_weer
wees76249122_wees
weet75254152_weet
wheep136214352wheep

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.1731032896.0
2DLD Change Limit53800981.75030742.9
3Display Results98980.0303266.7
 (SQL Overall)178691981.95391495.6
 
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.