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

165 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
widower143534(None) 
widowed1534841widowed
widowers1535111widowers
dower95027702__dower
endower1138482endower
widder112913972wid_der
widener11318692widener
wider94826362wid__er
widow1278942widow__
widowered1742752widowered
widows1376562widow_s
willower14127462willower
windowed1635572windowed
windrower1644232windrower
winnower1444252winnower
adorer74713453_adorer
aider65431143aid__er
airpower1343983airpower
avower1236823_avower
bidder104114863bid_der
bider85728383bid__er
blower115316573_blower
bower107328183__bower
cider84723323cid__er
cower104531773__cower
crower114117563_crower
diddler103511513diddler
didoes85716963dido_es
doer57734703__do_er
doper86128393__doper
doser66228563__doser
doter65428623__doter
dowed104632613__dowed
dowel95618193__dowel
dowers104523293__dowers
dowery134311663__dowery
downer104414923__downer
dowser104716083__dowser
dozer158419273__dozer
eider64624753eid__er
embower14267413embower
empower14217033empower
endowed1248173endowed
endowers1238233endowers
fiddler12309953fiddler
flower124815503_flower
giddier10308723giddier
glower105114933_glower
grower104614933_grower
hider95024093hid__er
idler65015663_id_ler
imbower14235663imbower
impower14247123impower
indowed1237443indowed
ironer64216453_ironer
isomer8310153_isomer
kidder123811113kid_der
knower1337083_knower
kotower1434383kotower
lower85830413__lower
miaowed1333883miaowed
middler112712273middler
misdoer1048633misdo_er
mower104523453__mower
piddler112911523piddler
plower114315063_plower
power105325953__power
prower114218123_prower
repower12329883repower
ridder84015143rid_der
riddler93411263riddler
rider65231313rid__er
ridgier937883ridgier
rioter64817283ri_oter
rower85430493__rower
shadower1544873shadower
shower124315113_shower
sidler74716963sid_ler
slower94016153_slower
sower85229313__sower
thrower1387003thrower
tiddler93110003tiddler
tidier73515113tid_ier
tower85729203__tower
twiddler13244873twiddler
undoer73113043undo_er
viewer1237213vi_ewer
vower115220793__vower
wadder114215483wad_der
waddler124010793waddler
wader95325373wad__er
wagoner1136093wagoner
wallower14158943wallower
warpower1645053warpower
wedder113612303wed_der
wedgier12428283wedgier
whooper15297153whooper
wicker154518673wi_cker
widders123512273wid_ders
widdie113410733widdie_
widdies123514033widdies
widdle113814843widdle_
widdled133511233widdled
widdles123514343widdles
wide85235423wid__e_
widen94717983wid__en
widened12328053widened
wideners12257993wideners
wides94832833wid__es
widget113815263wid_get
widowbird1951213widowbird
widowing1635183widowing
wielder11197673wielder
wiener94513543wi_ener
wiftier13297733wiftier
wiggier12418863wiggier
wiggler123110763wiggler
wilder103616473wi_lder
wildflower20112753wildflower
wildfowler2081593wildfowler
wilier93217073wi_lier
willer94021063wi_ller
willowed15156773willowed
willowers15166693willowers
willowier1563783willowier
willpower1773193willpower
wimpier14248053wimpier
wincer115018193wi_ncer
wincher153410653wincher
winder104025263wi_nder
windflower20133013windflower
windhover1942463windhover
windier113412163windier
window1347363window__
windows1447743window_s
windowy1744643window_y
windrowed1743723windrowed
windrowers1743843windrowers
winger104125443wi_nger
wingier113413283wingier
wingover1544303wingover
winier94522453wi_nier
winker134220293wi_nker
winner94219933wi_nner
winnowed1543473winnowed
winnowers1543953winnowers
winoes94317013wino_es
winsomer1345773winsomer
winter94222803wi_nter
wiper105421293wi__per
wirer85124953wi__rer
wirier94215553wi_rier
wiser85522803wi__ser
wisher123617063wi_sher
wispier12249403wispier
wither124321353wi_ther
withier132910493withier
wittier103910823wittier
wiver115924513wi__ver
woodier113912063woodier
wooer84316693w__ooer
woofer124411363w_oofer
wooler93615873w_ooler
wowed124023773w__owed
wowser125110203w__owser

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 Limit1340271655.95322514.2
3Display Results1651650.0632619.0
 (SQL Overall)1786911656.42227824.8
 
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.