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

91 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
wedel9451396(None) 
bedel84219401bedel
wedeln10326691wedeln
wedels103811031wedels
weel75834081we_el
aedes64625152aedes
bedell93610042bedell
bedels94015272bedels
bedew114513042bedew
betel74419902betel
bevel104517042bevel
bezel165215172bezel
cede74928772cede_
ceded96118562ceded
ceder85322242ceder
cedes84927332cedes
dedal75719022dedal
del46752752__del
devel94217122devel
eel37946842_e_el
fedex1699602fedex
feel75233842fe_el
heder95623642heder
heel75034222he_el
jebel145612142jebel
jewel156711702jewel
keel85729472ke_el
kevel124213102kevel
level84116552level
medal86221332medal
model84521692model
newel86114132newel
pedal86022502pedal
pedes85327292pedes
peel65535612pe_el
rebel73421292rebel
rede55037672rede_
reded74829122reded
redes65139132redes
reel45240532re_el
refel84920812refel
repel74921402repel
revel84423162revel
seder64826762seder
seel45042982se_el
seidel7311082seidel
swede94413202swede_
swedes102711892swedes
teel46335802te_el
wade85237062wade_
waded106024752waded
wader95325362wader
wades95634142wades
wadmel1235522wadmel
weal75838682we_al
weasel93410522weasel
weber10313522weber
wed75843622wed__
wedded123811842wedded
wedder113612302wedder
wedeled1237782wedeled
wedelns11325242wedelns
wedge105215662wedge
wedged125110302wedged
wedges114614582wedges
wedgy13479802wedgy
weds86628932wed_s
wee66760812we_e_
weed85637512we_ed
weeded113914872weeded
weeder103315512weeder
weeds95222212weeds
weedy125115002weedy
week116428152we_ek
ween75835462we_en
weep95131652we_ep
weer75535092we_er
wees76249122we_es
weet75254152we_et
welded114013382welded
welder102914412welder
well75832042we_ll
wended113616152wended
were76238332were_
wheel115515332wheel
wide85235412wide_
widely133311032widely
widen94717972widen
wider94826352wider
wides94832822wides
yodel94714082yodel

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.330541487.9
2DLD Change Limit53800911.37339184.3
3Display Results91910.0332757.6
 (SQL Overall)178691911.736102932.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.