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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

184 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
wedelns1132524(None) 
wedeln10326691wedeln_
wedels103811031wedel_s
bedells10379362bedells
bedels94015272bedel_s
wedel94513962wedel__
wedeled1237782wedeled
wedeling1338772wedeling
weens85224052we_e_ns
widens106212722wide_ns
aedes64625153aede__s
aediles83413903aediles
bedamns1235733bedamns
bedecks1635793bedecks
bedel84219403bedel__
bedell93610043bedel_l
bedews12398943bede_ws
bedless1039703bedless
bedpans1237173bedpans
beduins1039123beduins
bemeans1148743bemeans
betels84515063betel_s
bevels113913983bevel_s
bezels173712283bezel_s
ceders93817673cede_rs
cedes84927333cede__s
cedulas1058503cedulas
codeins103715483codeins
codens94821013code_ns
deadens93410693deade_ns
deans66131393__deans
decerns10119053decerns
dedans85915073ded_ans
deles65139253__deles
delfs94918673__delfs
delis64928543__delis
dells66630943__dells
dels56745473__del_s
delts65731793__delts
demeans1039723demeans
dens55945073__de_ns
deveins1138813deveins
devels104313903devel_s
dudeens934863dudeens
edemas9310503_edemas
ediles74016983_ediles
eels46536743_e_el_s
evens84817103_eve_ns
fadeins1168503fadeins
fedexes1835473fedexes
feels85223043fe_el_s
heddles123311623heddles
heders104119763hede_rs
heels85625533he_el_s
jebels15418913jebel_s
jewels16508613jewel_s
keels94622413ke_el_s
keens95721183ke_e_ns
kevels134410713kevel_s
ladens74516233lade_ns
leadens83610983leade_ns
lebens8310093lebe_ns
levels94113283level_s
lodens74315063lode_ns
medals94218063medal_s
meddles113213253meddles
medians103214213medians
medleys13115333medleys
models94216363model_s
moderns1037963moderns
needles83211563needles
newels93710823newel_s
odeons739023_odeons
oedemas1056693oedemas
pedalos10329703pedalos
pedals94316033pedal_s
peddles112913703peddles
pedes85327293pede__s
pedlers103013273pedlers
peels75226423pe_el_s
peens76428193pe_e_ns
pereons92815003pereons
rebels84518133rebel_s
redans75421023red_ans
reddens9259783reddens
reddles93315773reddles
redears82814453redears
redeems1037163redeems
redeny102712733rede_ny
redes65139133rede__s
redeyes112910973redeyes
redfins1139923redfins
redlegs936823redlegs
redons75222183red_ons
reels55333263re_el_s
refels94618053refel_s
remelts93511493remelts
repels84318763repel_s
resells73313203resells
retells73211523retells
revels94220573revel_s
rewelds11457413rewelds
secerns987733secerns
sedans74816093sed_ans
seders74420283sede_rs
seels55632823se_el_s
seidels838393seidel_s
semens84616973seme_ns
sereins73716123sereins
sevens93813663seve_ns
swedes102711893swede__s
swevens1334613sweve_ns
teels55726373te_el_s
teens56227483te_e_ns
tweedles1234113tweedles
tweens9489843twe_e_ns
waddles124314843waddles
waders109120643wade_rs
wades95634143wade__s
wadmels1334303wadmel_s
wakens135012043wake_ns
wardens113711903warde_ns
weakens14367063weakens
weakons14287803weakons
wealds10459103we_alds
weals85428743we_al_s
weans85326743w__eans
weapons12278603weapons
weasels10468503weasel_s
weasons102310583weasons
webers11310943webe_rs
webless1237003webless
wedders123610723wedders
wedding133411873wedding
weddings14355533weddings
wedges114614583wed_ges
wedgies123910213wedgies
wedging13308723wedging
weds86628933wed___s
weeders113412933weeders
weeding123815213weeding
weedless12287963weedless
weeds95222213we_e_ds
weeks125017863we_e_ks
weel75834083we_el__
ween75835463we_e_n_
weensy12416823we_e_nsy
weeny115316163we_e_ny
weeps104120563we_e_ps
wees76249123we_e__s
weets85427723we_e_ts
weigelas1243103weigelas
welders113313413welde_rs
weldless12285813weldless
welds94719163w__elds
welkins1437173welkins
wells85426193w__ells
welts85225193w__elts
wens76337933w__e_ns
wergelds1342293wergelds
wergelts1253413wergelts
westerns11328963westerns
wheedles1534643wheedles
wheels123811713wheel_s
wheens124610613w_heens
whelks16367323w_helks
whelms14377573w_helms
whelps14437843w_helps
whens114618763w_he_ns
widdles123514343widdles
widely133311033widel_y
widen94717973wide_n_
wides94832823wide__s
widgeons1343853widgeons
wields10469623w_ields
wigeons1136983wigeons
wiverns13366963wiverns
wizens186110263wize_ns
woolens10398843woolens
wovens12449833wove_ns
wrens85016243w_re_ns
wyverns16363013wyverns
yeelins1038813ye_elins
yodels104610073yodel_s

Search took 8 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 Filter1786911340270.406440125.6
2DLD Change Limit1340271847.22018563.3
3Display Results1841840.0632920.6
 (SQL Overall)1786911847.68923239.8
 
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.