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

235 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
widener1131869(None) 
widened12328051widened
wideners12257991wideners
wiener94513541wi_ener
livener10278942livener
ripener937912ripener
wakener1446912wakener
whitener1435742whitener
widder112913972wid_der
widen94717982widen__
wideness12259472wideness
widens106212722widen_s
wider94826362wid__er
widower1435342widower
wieners103212482wi_eners
winner94219932wi_nner
wizened20275422wizened
woodener1245762woodener
aider65431143aid__er
aliener71011193aliener
awakener1543433awakener
bidder104114863bid_der
bider85728383bid__er
biner75930693bi__ner
burdener1136143burdener
cider84723323cid__er
cozener18328953cozener
deadener1036743deadener
deer56739023__de_er
defer94619753__defer
denar65223293__denar
dene56643413__dene_
denes65639723__denes
denier74420693__denier
denser74115193__denser
deter65028043__deter
diddler103511513diddler
diene65720133di_ene_
dienes75719903di_enes
dieter73516773di_eter
dimeter10411893dimeter
diner65632903__diner
dinner74217163di_nner
diviner11369883diviner
dizened18267333dizened
eider64624753eid__er
evener91010623_evener
fiddler12309953fiddler
fidgeter1343783fidgeter
finer85431563fi__ner
gardener1037113gardener
giddier10308723giddier
ginner73915823gi_nner
goldener1045403goldener
greener83111713greener
hardener1238883hardener
hider95024093hid__er
hinderer1238273hinderer
hoidened1335653hoidened
idler65015663_id_ler
inaner62213543_inaner
indene73215373indene_
indenes82916253indenes
indenter92311443indenter
indexer15287253indexer
inner54920633_i_nner
ironer64216453_ironer
keener104012843_keener
kidder123811113kid_der
kidney1434773kid_ney
ladened979053ladened
libeler9219003libeler
licencer12146143licencer
licenser10155883licenser
lieder74912323li_eder
liefer9529573li_efer
liever94611863li_ever
likened12267353likened
limner84112873li_mner
liner55938923li__ner
listener8158313listener
livened11238933livened
liveners11217933liveners
middler112712273middler
mildened1235773mildened
miner76933543mi__ner
misenter10310833misenter
miterer92511333miterer
modeler1039293modeler
moderner1145523moderner
oftener1035923oftener
opener83910993_opener
orderer8127943orderer
piddler112911523piddler
piecer105213083pi_ecer
pilsener1044753pilsener
pilsner935343pilsner
pinene82915653pinene_
pinenes93416693pinenes
pinner84521503pi_nner
pioneer936893pioneer
preener93114833preener
ravener104110743ravener
rewidened1444073rewidened
ridder84015143rid_der
riddler93411263riddler
rident7520193riden_t
rider65231313rid__er
ridgier937883ridgier
riever94811653ri_ever
ripened1038213ripened
ripeners1036843ripeners
riveter10208753riveter
serener73415763serener
sickener1436603sickener
sidebar1045563sidebar
sidecar1045233sidecar
sideliner10126013sideliner
sidemen1037943sidemen
sidler74716963sid_ler
signer74015633si_gner
silencer1036303silencer
silenter838873silenter
sinner64320603si_nner
teener64717503_teener
tiddler93110003tiddler
tidier73515113tid_ier
tinner64119963ti_nner
tireder837703tireder
tweener10306833tweener
twiddler13244873twiddler
twiner94012593twi__ner
viewer1237213vi_ewer
vintner1034833vintner
wadder114215483wad_der
waddler124010793waddler
wader95325373wad__er
wagerer11328493wagerer
wagoner1136093wagoner
wakened1546873wakened
wakeners1535843wakeners
wanderer122210123wanderer
wanner94019623w_anner
warner93717223w_arner
warrener1136923warrener
waterer103314083waterer
waverer13319523waverer
weakener1534913weakener
weaner93816773w_eaner
weber10313523w__eber
wedder113612303wed_der
wedeled1237783wedeled
wedgier12428283wedgier
weeder103315513w_eeder
weedier113810623weedier
weened104013733w_eened
weenier103210803w_eenier
weeper114313303w_eeper
weer75535093w__e_er
weever123811443w_eever
weiner94214133w_einer
wheeler13298783wheeler
wheezer22296683wheezer
whiner124516633w_hiner
whitened1535183whitened
whiteners1535253whiteners
whoever1634103whoever
wickeder1843983wickeder
wicker154518673wi_cker
widders123512273wid_ders
widdie113410733widdie_
widdies123514033widdies
widdle113814843widdle_
widdled133511233widdled
widdles123514343widdles
wide85235423wid__e_
widely133311033wide_ly
widening13237833widening
wideout1179033wideout
wides94832833wid__es
widest104517003wide_st
widget113815263wid_get
widowed1534843widowed
widowers1535113widowers
wielder11197673wielder
wienie9229973wi_enie
wienies102213683wi_enies
wifelier1434853wifelier
wiftier13297733wiftier
wiggier12418863wiggier
wiggler123110763wiggler
wilder103616473wi_lder
wildered1336633wildered
wilier93217073wi_lier
willer94021063wi_ller
wimpier14248053wimpier
wincer115018193wi_ncer
wincher153410653wincher
winder104025263wi_nder
windier113412163windier
wine74953433wi__ne_
wined94434183wi__ned
winery125014283wi__nery
wines85546863wi__nes
winey115325433wi__ney
winger104125443wi_nger
wingier113413283wingier
winier94522453wi_nier
winker134220293wi_nker
winned104017013wi_nned
winners104316913wi_nners
winter94222803wi_nter
winterer112110443winterer
wiper105421293wi__per
wiremen1236903wiremen
wirer85124953wi__rer
wirier94215553wi_rier
wiselier1137363wiselier
wiseness112010753wiseness
wisent93516343wisen_t
wisents10249063wisents
wiser85522803wi__ser
wisher123617063wi_sher
wispier12249403wispier
wither124321353wi_ther
witherer14187953witherer
withier132910493withier
witney12356843wi_tney
wittier103910823wittier
wiver115924513wi__ver
wizen175813863wizen__
wizens186110263wizen_s
wonderer12249183wonderer
wonner95114443w_onner
yodeler1136343yodeler

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.406440125.6
2DLD Change Limit1340272356.42320866.7
3Display Results2352350.0932526.9
 (SQL Overall)1786912356.92225814.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.