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

239 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
windows144774(None) 
indows104210791_indows
widows1376561wi_dows
window1347361window_
windowy1744641windowy
windrows1546161windrows
winnows1334531winnows
endows104610422_endows
indols74714202_indols
indow95011662_indow_
minnows1234912minnows
widow1278932wi_dow_
willows13299752willows
winders113721262winders
windles113518492windles
windowed1635572windowed
windrow1445852windrow_
winds95425602wind__s
windups1334782windups
wingbows1743982wingbows
winnow1234592winnow_
winoes94317012win_oes
winos84625042win_o_s
wisdoms1335452wisdoms
bandogs1138363bandogs
billows123611293billows
binders103920743binders
bindis94614583bind_is
bindles104016453bindles
binds86627473bind__s
bingoes104013983bingoes
bingos95514793bingo_s
binocs1039923bin_ocs
candors104216763candors
cinders104617763cinders
cineols9128853cineols
condoes104319203condoes
condoms124214083condoms
condors104018573condors
condos94322333condo_s
didoes85716963di_does
didos76820813di_do_s
dildoes9229243dildoes
dildos8179303dildo_s
dindles93817243dindles
dingoes94114833dingoes
dinos65428063din_o_s
disendows1444083disendows
dows85941053___dows
dwindles13366023dwindles
eidos65817753ei_do_s
endow94510983_endow_
enows85115493_en_ows
fandoms13229473fandoms
fidos95819053fi_do_s
finders113717873finders
finds95424823find__s
finos86226953fin_o_s
ginzoes1735433ginzoes
gundogs1034603gundogs
hinders113718503hinders
hinds96721473hind__s
idols65514133_i_dols
incogs937903_incogs
indies73822783_indies
indol63714873_indo_l
indole74516053_indole
indoles83716363_indoles
indoor738403_indoor
indoors838553_indoors
indorse8108193_indorse
indowed1237443_indowed
indris7311963_indris
indues73515263_indues
inflows1335523_inflows
infos84311673_info_s
ingots7912063_ingots
inions64417003_inions
intown936153_intown
iodous7311503_iodous
jingoes153811443jingoes
kendos114510663kendo_s
kiddoes13387063kiddoes
kiddos12416863kiddo_s
kindles123614843kindles
kinds106221813kind__s
kingdoms1643693kingdoms
kinos96626143kin_o_s
knows124912413_kn_ows
lidos65219883li_do_s
lindens839413lindens
lindies8416583lindies
lingoes84014693lingoes
linos55631503lin_o_s
lintols7339553lintols
meadows1337333meadows
miaows1145473mi_aows
mildews13365883mildews
minders103720123minders
minds85427123mind__s
minions93314623minions
minnow1135583minnow_
minors85117103min_ors
misdoes10312493misdoes
mondos95217333mondo_s
ninons64913773nin_ons
nows75738233__n_ows
pillows122610123pillows
pinders103720473pinders
pingoes105116523pingoes
pingos95317673pingo_s
pinions93413603pinions
pinkoes135512313pinkoes
pinkos125313873pinko_s
pinons86019943pin_ons
pinots85920273pin_ots
pintoes95117713pintoes
pintos86021293pinto_s
pinyons12299003pinyons
qindars17267423qindars
rainbows1343243rainbows
randoms102112433randoms
reendows12234683reendows
rinds64826143rind__s
rondos74616733rondo_s
rundown1165443rundown
rundowns1284533rundowns
shadows1437193shadows
sinews94210623sin_ews
sinuous739063sinuous
snows84719893_sn_ows
sunbows1236023sunbows
sundews11398153sundews
sundogs947103sundogs
sundown1186313sundown
sundowns1285433sundowns
swindles12319503swindles
tendons8311473tendons
thindown1543373thindown
thindowns1642673thindowns
tinders84219173tinders
tondos75115923tondo_s
undoes73917403_undoes
vendors113510223vendors
vinos84723073vin_o_s
vinous93914173vin_ous
wallows133613533wallows
wanders114221333wanders
wands96425483wand__s
wanions104011373wanions
wantons103713013wantons
weirdoes12323833weirdoes
weirdos11355123weirdo_s
weldors11238003weldors
wends95822813wend__s
whitlows1743083whitlows
widders123512273widders
widdies123514033widdies
widdles123514343widdles
widens106212723wi_dens
wides94832823wi_d_es
widowed1534843wi_dowed
widower1435343wi_dower
widowers1535113wi_dowers
widths1335123wi_dths
wifedoms1743463wifedoms
wigeons1136983wigeons
wilders113513503wilders
wildfowl1842243wildfowl
wildfowls1952083wildfowls
wilds94818203wild__s
willow12369693willow_
willowy16276353willowy
wincers123415363wincers
winces114819113win_ces
winceys15395523winceys
winches154714373winches
wind85533853wind___
windage1237933windage
windages1338263windages
windbag1444123windbag
windbags1544523windbags
windblown1851793windblown
winded114918213wind_ed
winder104025263wind_er
windflaws1942403windflaws
windier113412163windier
windiest122213233windiest
windigo12415953windigo
windigos13484903windigos
windily1437943windily
winding123517913winding
windings13329973windings
windlass12266083windlass
windle104617953wind_le
windled123713483windled
windless123310863windless
windowing1744813windowing
windowless1742353windowless
windowsill175993windowsill
windrowed1743713windrowed
windrower1644223windrower
windrowers1743843windrowers
windsock1843183windsock
windsocks1943073windsocks
windthrows2051563windthrows
windup1235383wind_up
windway1745153windway
windways1845043windways
windy126118103wind__y
wines85546863win__es
winesops1374663winesops
wingbow1643773wingbow_
wingers113921483wingers
wings95727243win__gs
winkers143517113winkers
winkles143412773winkles
winks125325433win__ks
winless103212283winless
winners104316913winners
winnock1643893winnock
winnocks1743873winnocks
winnowed1543463winnowed
winnower1444253winnower
winnowers1543953winnowers
wino75933613win_o__
wins75949173win___s
winsome1237463winsome
winters103720483winters
wintles103414983wintles
winzes184313053win_zes
wisdom1235983wisdo_m
wittols1035733wittols
wonders113315993wonders
wondrous1246823wondrous
wontons103310533wontons
wows104633493w___ows
wynds126310373wynd__s
zincous1837053zincous

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.1531167915.0
2DLD Change Limit1340272397.11018850.5
3Display Results2392390.0962489.6
 (SQL Overall)1786912397.35924282.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.