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

195 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
wideners1225799(None) 
widener11318691widener_
wideness12259471wideness
wieners103212481wi_eners
liveners11217932liveners
ripeners1036832ripeners
wakeners1535842wakeners
whiteners1535242whiteners
widders123512272wid_ders
widened12328052widene_d
widens106212722widen__s
widowers1535112widowers
wiener94513542wi_ener_
winners104316912wi_nners
wiseness112010752wiseness
aiders74524633aid__ers
alieners889823alieners
awakeners1643093awakeners
bidders114012313bid_ders
biders94822803bid__ers
biners85023633bi__ners
burdeners1245063burdeners
ciders94620093cid__ers
cozeners19297783cozeners
deadeners1146283deadeners
deers64930523__de_ers
defers105116943__defers
denars74621433__denars
denes65639723__dene_s
deniers84515183__deniers
deters74724683__deters
diddlers11359153diddlers
dienes75719903di_ene_s
dieters83216433di_eters
dimeters11411093dimeters
diners75525953__diners
dinners83915443di_nners
direness9311303direness
diviners12308353diviners
eiders74321363eid__ers
eveners10109503_eveners
fiddlers13328283fiddlers
fidgeters1443623fidgeters
fineness11310643fineness
gardeners1136603gardeners
ginners84314223gi_nners
hardeners1338083hardeners
hideless12278713hideless
hiders104919653hid__ers
hinderers1337353hinderers
idleness936843_idleness
idlers74012813_id_lers
indenes82916253indene_s
indenters102710033indenters
indexers16326373indexers
inners63919353_i_nners
ironers74813553_ironers
keeners113610783_keeners
kidders13399173kid_ders
kidneys1533423kid_neys
libelers10238623libelers
licencers13134643licencers
licensers11114583licensers
likeness12229863likeness
limners93311563li_mners
liners65428853li__ners
listeners9147323listeners
liteness82213213liteness
livener10278943livener_
liveness112411393liveness
middlers123410193middlers
miners84126633mi__ners
misenters1139533misenters
miterers10219683miterers
modelers1138463modelers
niceness1039843niceness
nudeness936733nudeness
openers9339493_openers
orderers9116563orderers
piddlers12359593piddlers
piecers114112253pi_ecers
pilseners1144943pilseners
pilsners1035533pilsners
pinenes93416673pinene_s
pinners93518603pi_nners
pioneers1035863pioneers
preeners102712813preeners
raveners11309133raveners
ridders93612493rid_ders
riddlers10269103riddlers
riders74123903rid__ers
rievers104311453ri_evers
rifeness1138583rifeness
ripener937903ripener_
ripeness1039363ripeness
riveters11228163riveters
rudeness938083rudeness
sickeners1535733sickeners
sidebars1146643sidebars
sidecars1145903sidecars
sidedness1146783sidedness
sideliners11125133sideliners
sidlers83414233sid_lers
signers84714443si_gners
silencers1145283silencers
sinners74019023si_nners
snideness1067683snideness
teeners74415453_teeners
tiddlers10288653tiddlers
tideless9269083tideless
tidiers8389773tid_iers
tidiness938793tidiness
tinners73717313ti_nners
tweeners11306243tweeners
twiddlers14313693twiddlers
twiners10459633twi__ners
viewers1337173vi_ewers
vileness1139983vileness
vintners1134573vintners
wadders123812443wad_ders
waddlers13298333waddlers
waders109120643wad__ers
waeness102512783w_aeness
wagerers12247613wagerers
wagoners1235473wagoners
wakener1446913wakener_
wanderers13228483wanderers
warners103315563w_arners
warreners1236193warreners
waterers112312783waterers
waverers14318613waverers
weakeners1644163weakeners
weaners104613833w_eaners
webers11310943w__ebers
wedders123610723wed_ders
weeders113412933w_eeders
weepers123511973w_eepers
weevers13379993w_eevers
weiners103913063w_einers
wheelers14287733wheelers
wheezers23265273wheezers
whiners134011573w_hiners
whitener1435733whitener_
whiteness1546483whiteness
wickers164114703wi_ckers
widder112913973wid_der_
widdies123514033widdie_s
widdles123514343widdle_s
widen94717973widen___
widenesses1438773widenesses
widening13237833widening
wideouts1275233wideouts
wider94826353wid__er_
wides94832823wid__e_s
widgets12318453wid_gets
widower1435343widower_
wielders12196613wielders
wienies102213683wi_enies
wifeless14277483wifeless
wigglers13257213wigglers
wilderness1443513wilderness
wilders113513503wi_lders
wildness1236203wildness
wiliness1139113wiliness
willers103517913wi_llers
wincers123415363wi_ncers
winchers16319223winchers
winders113721263wi_nders
windiness1337373windiness
wineless112711173wineless
winery125014283wi__nery
wines85546863wi__ne_s
wingers113921483wi_ngers
winkers143517113wi_nkers
winner94219933wi_nner_
winterers12209723winterers
winters103720483wi_nters
wipers115416083wi__pers
wireless11249633wireless
wirers94617893wi__rers
wiriness1138953wiriness
wisents10249063wisen_ts
wishers133215213wi_shers
witherers15146843witherers
withers134417753wi_thers
witness103010013wi_tness
witneys13274723wi_tneys
wivers125320803wi__vers
wizened20275423wizene_d
wizens186110263wizen__s
woeness1020211543w_oeness
wonderers13217933wonderers
wonners104312813w_onners
woodener1245763woodener_
yodelers1235673yodelers

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 Filter1786911461620.453394461.4
2DLD Change Limit1461621957.42019698.4
3Display Results1951950.0802437.5
 (SQL Overall)1786911957.95322468.4
 
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.