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

249 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
dizened1826733(None) 
dozened18377451dozened
wizened20275421wizened
bedizened2242752bedizened
cozened19349182cozened
davened124610072davened
denizened2042752denizened
diene65720132di_ene_
dienes75719902di_enes
dieted83115492di_eted
dined76431992di__ned
dinned84317612di_nned
divined12329692divined
dizen155214932dizen__
dizens164911392dizen_s
dizzied17236132dizzied
dovened12389062dovened
likened12267352likened
livened11238932livened
ripened1038202ripened
widened12328052widened
aliened81011743aliened
binned94414543bi_nned
bizone1738603bizone_
bizones1837823bizones
brazened20134903brazened
cozener18328953cozener
daikered1495223daikered
damned104212913d_amned
dampened1435623dampened
darkened1435943darkened
darned85018483d_arned
dawned113912093d_awned
dazed165919363daz__ed
dazzled1735033dazzled
deadened1137233deadened
deafened1335853deafened
deaned84620453d_eaned
deboned113411633deboned
decerned1237263decerned
deed65340903d__e_ed
deeded94615543d_eeded
deemed104713063d_eemed
deepened1235653deepened
defenced1537203defenced
defend113910493defen_d
defended1437223defended
defensed1336223defensed
defined123813823defined
deigned1037503deigned
deked115718533d__eked
deled75326543d__eled
deleted93314903deleted
demeaned1237283demeaned
demented12311273demented
dene56643413d__ene_
denes65639723d__enes
denied84318633d__enied
denned84215633d_enned
dented84120513d__ented
depend103510923depen_d
depended1337983depended
deponed113712873deponed
desexed1636173desexed
deveined1336673deveined
develed123611933develed
dewed105020303d__ewed
dezinced2183903dezinced
diademed1344153diademed
dialed84716453di_aled
dialled9510133dialled
diapered1238003diapered
diazine1738933diazine_
diazines1838713diazines
dibbed124713473di_bbed
dibbled133510843dibbled
diced95824683di__ced
dicked144920863di_cked
dickered16117533dickered
diddled114212053diddled
died66137853di___ed
diesel74410403di_esel
dieseled1035523dieseled
dieses75218693di_eses
dieter73516773di_eter
differed1635523differed
digested11208163digested
digged104314653di_gged
dighted132511493dighted
diked115024683di__ked
dilated93115823dilated
dilled84122223di_lled
diluted9248933diluted
dimeter10411893dimeter
dimmed124110323di_mmed
dimpled132810303dimpled
dindled104412723dindled
dine55555333di__ne_
diner65632903di__ner
dines66449153di__nes
dinged95221783di_nged
dinked124818353di_nked
dinner74217163di_nner
dinted84419843di_nted
dipnet91317473di_pnet
dipped123517493di_pped
directed1238233directed
direness9311303direness
dirked124912273di_rked
dirled84514903di_rled
dirtied93210853dirtied
disced104914653di_sced
discerned1347863discerned
discoed11312483discoed
diseased103011713diseased
dished114318713di_shed
disked125015763di_sked
disowned1336433disowned
dispend11289413dispen_d
dispended14147823dispended
dispensed13158773dispensed
dissed85220183di_ssed
dissented1199723dissented
distend93312073disten_d
distended12157923distended
disused93211033disused
ditched143711903ditched
dithered13189293dithered
dittoed936733dittoed
dived106321373di__ved
diverged14256883diverged
diverted13199583diverted
divested13268213divested
divided13378593divided
divine103514463divine_
diviner11369883diviner
divines113514723divines
divvied1544813divvied
dizening19177143dizening
dizenment2145823dizenment
dizzier16317543dizzier
dizzies16279753dizzies
donned85015743d_onned
doweled12269773doweled
dowered122811553dowered
downed115314783d_owned
dozed165619353doz__ed
dozen155017473dozen__
dozens164612463dozen_s
dozenth2044323dozenth
drained93713253drained
dreed75222843d_re_ed
driveled1374973driveled
drizzled18284573drizzled
droned84616863d_roned
drowned12419903drowned
dueled84813663d_ueled
duende836923d_uende
dueted84113593d_ueted
dunned85015523d_unned
durned84113173d_urned
dwined114610213d_wined
evened101010313_evened
fibered1337643fibered
fiend95312983fi_en_d
fileted1159093fileted
fined94930503fi__ned
finned104114603fi_nned
fizzed18369443fiz_zed
fizzled19357273fizzled
ginned83813983gi_nned
girned84010513gi_rned
greened93111263greened
havened14429243havened
hoidened1335653hoidened
inned64118423_i_nned
ironed74916013_ironed
itemed936603_itemed
keened114013623_keened
kilned11368393ki_lned
kirned11408623ki_rned
kittened1334523kittened
ladened979053ladened
latened8711923latened
libeled10249413libeled
licenced13145773licenced
licensed11145723licensed
lichened1435753lichened
limned94811473li_mned
lined64934643li__ned
lippened13255223lippened
listened9168813listened
livener10278943livener
livered113111633livered
mildened1235773mildened
mimeoed1235193mimeoed
mined85333353mi__ned
mitered103213233mitered
mittened1136363mittened
mizen164815273mizen__
mizens174610253mizen_s
mizzled18327633mizzled
omened93711003_omened
opened94311863_opened
peened94318153_peened
pieced113912103pi_eced
pined85935323pi__ned
pinene82915643pinene_
pinenes93416673pinenes
pinkened1535753pinkened
pinned94818383pi_nned
preened103214983preened
queened17105863queened
ravened115012283ravened
razeed163710013raze_ed
rezoned173611163rezoned
richened1435953richened
ripener937903ripener
riveted11258573riveted
sheened113511703sheened
sickened1546783sickened
sieged85212713si_eged
sieved104611443si_eved
signed83413753si_gned
silenced1136273silenced
sinewed1137053sinewed
sinned73818413si_nned
sized155519243siz__ed
sizzled16367883sizzled
tiered73613973ti_ered
tined65434533ti__ned
tinned74317533ti_nned
tokened1236393tokened
unzoned172310653unzoned
viewed1345993vi_ewed
vined95626153vi__ned
viseed105310983vise_ed
vizored2034133vizored
wakened1546873wakened
weened104013733_weened
whitened1535173whitened
widener11318693widener
wiener94513543wi_ener
wined94434183wi__ned
winned104017013wi_nned
wizen175813863wizen__
wizens186110263wizen_s
zizzled15315853zizzled
zoned154020263__zoned

Search took 7 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.1401276364.3
2DLD Change Limit1340272495.94022563.5
3Display Results2492490.0763276.3
 (SQL Overall)1786912496.15629027.1
 
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.