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

343 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
winchers1631922(None) 
inchers123912521_inchers
pinchers153510611pinchers
wenchers16319211wenchers
wincers123415361winc_ers
wincher153410651wincher_
winches154714371winche_s
benchers153611012benchers
cinches144215772cinche_s
clinchers16336262clinchers
ditchers143610362ditchers
filchers16286862filchers
finches153914192finche_s
flinchers17295472flinchers
hitchers16379992hitchers
incher114114032_incher_
inches114419672_inche_s
lunchers13349562lunchers
lynchers16285452lynchers
mincers113714842minc_ers
munchers15318772munchers
pincers113916502pinc_ers
pincher143812712pincher_
pinches144117932pinche_s
pinschers1644372pinschers
pitchers153211482pitchers
punchers152610072punchers
ranchers133311792ranchers
switchers17146632switchers
twitchers17134532twitchers
watchers163511792watchers
welchers16338052welchers
wencher153811132wencher_
wenches152914132wenche_s
wiches144418752wi_che_s
wickers164114702wi_ckers
wincer115018192winc_er_
winces114819112winc_e_s
winceys15395522winc_eys
winched163110592winche_d
winders113721262win_ders
wingers113921472win_gers
winkers143517112win_kers
winners104316902win_ners
winters103720472win_ters
wishers133215212wi_shers
witchery19236092witchery
witches152715792witche_s
withers134417752wi_thers
wrenchers17256332wrenchers
aitches123014363aitche_s
anchors123912953_anchors
anthers103715203_anthers
archers124414573_archers
batchers153613273batchers
belchers153510023belchers
bencher144113483bencher_
benches143918603benche_s
bewitchers2042563bewitchers
bickers154316553bi_ckers
binders103920743bin_ders
biners85023633bin__ers
bingers104519983bin_gers
birches143412323birche_s
bitchery18236563bitchery
bitches144117063bitche_s
blanchers16307433blanchers
blenchers16356723blenchers
bluchers15359033bluchers
botchers153511543botchers
brunchers16296253brunchers
bunches144116033bunche_s
butchers153710183butchers
cancers114018583canc_ers
catchers153114053catchers
chinches18369363chinche_s
cinched153910863cinche_d
cinders104617753cin_ders
ciphers14379983ci_phers
circlers1235343circlers
cithers124315753ci_thers
clenchers16276553clenchers
clincher15347663clincher_
clinches153910363clinche_s
coachers154312293coachers
conches144019813conche_s
couchers153513843couchers
crunchers16316243crunchers
dancers103413093danc_ers
dicers94720743di_c_ers
dickers144117663di_ckers
diethers1257453diethers
diners75525953din__ers
dingers94321373din_gers
dinners83915433din_ners
ditcher134012003ditcher_
ditches133215713ditche_s
dithers114016153di_thers
dowitchers1942133dowitchers
drenchers15296103drenchers
dunches133312583dunche_s
etchers123411293_etchers
fanciers13358083fanciers
fencers123810623fenc_ers
fetchers16328863fetchers
fiches145219533fi_che_s
filcher15377793filcher_
filches153410723filche_s
finders113717873fin_ders
fingers113418423fin_gers
finishers1545353finishers
fishers134714723fi_shers
fitches153516193fitche_s
fitchets16307413fitchets
fitchews19274773fitchews
flincher16256583flincher_
flinches16358953flinche_s
gingers94118633gin_gers
ginners84314213gin_ners
grinches1436943grinche_s
hatchers163113173hatchers
hinders113718503hin_ders
hingers113420193hin_gers
hinters103719573hin_ters
hitcher153712003hitcher_
hitches153616273hitche_s
hunches153913463hunche_s
ichors11310413_i_chors
ickers123914183_i_ckers
inched124514483_inche_d
inciters103210653_inciters
incomers1268583_incomers
incurs83012273_inc_urs
infers93615443_in_fers
inhere9313713_in_here
inheres10315173_in_heres
inkers104018833_in_kers
inliers73110743_inliers
inners63919343_in_ners
inters64328043_in_ters
itches114916213_itche_s
jinglers16408753jinglers
jinkers183511813jin_kers
kenches163912273kenche_s
kickers124013293ki_ckers
kimchees1942943kimchees
kindlers13318483kindlers
kitchens17195783kitchens
knickers13306723knickers
lancers93616643lanc_ers
lanciers10308543lanciers
launchers1454333launchers
leachers133712813leachers
lechers123313963_lechers
lichees123512783li_chees
lichens123510683li_chens
liches114724293li_che_s
lickers134118253li_ckers
liners65428843lin__ers
lingers84223293lin_gers
linkers114317703lin_kers
linters73822613lin_ters
luncher123111413luncher_
lunches124115443lunche_s
lurchers13307153lurchers
lyncher15366553lyncher_
lynches15378873lynche_s
manches143818623manche_s
manchets15269573manchets
marchers153710813marchers
matchers153012433matchers
miches134320733mi_che_s
mincer104017363minc_er_
minces104420803minc_e_s
mincier113512463mincier_
minders103720113min_ders
miners84126633min__ers
minglers113011283minglers
minivers1337473minivers
minsters103813913minsters
minters93822463min_ters
mithers123516733mi_thers
moochers15369123moochers
muncher143610373muncher_
munches144215793munche_s
niches114419143ni_che_s
nickers134415093ni_ckers
notchers13279423notchers
ochers113915303__ochers
painches1588913painche_s
panthers13510783panthers
patchers153413303patchers
peachers153213843peachers
perchers153611523perchers
pickers153718093pi_ckers
piecers114112253piec_ers
pincer104019173pinc_er_
pincheck2143383pincheck
pinchecks2243153pinchecks
pinched153812453pinche_d
pinders103720473pin_ders
pingers104020733pin_gers
pinkers134118603pin_kers
pinners93518593pin_ners
pinscher1544803pinscher_
pishers123815753pi_shers
pitcher143813713pitcher_
pitches143617753pitche_s
poachers152910763poachers
puncher143311673puncher_
punches144816133punche_s
quenchers2343173quenchers
rancher123013633rancher_
ranchero13277423ranchero
rancheros14255793rancheros
ranches123620113ranche_s
reachers133515723reachers
ricers84120993ri_c_ers
richens12349733ri_chens
richer114015043ri_cher_
riches115022083ri_che_s
ringers83922943rin_gers
rinsers73815743rin_sers
sighers113712173si_ghers
sincere9310553sinc_ere
singers83824693sin_gers
sinkers113618543sin_kers
sinners74019013sin_ners
sinters74024073sin_ters
snickers143010963snickers
snitchers14166043snitchers
stanchers14206803stanchers
stitchers14146993stitchers
swindlers13306033swindlers
swineherd1682253swineherd
swineherds1791773swineherds
swingers123710423swin_gers
swishers14328053swi_shers
switcher16177683switcher_
switches16159133switche_s
swithers144310533swi_thers
teachers133212393teachers
tenches123515523tenche_s
tickers133617723ti_ckers
tinders84219173tin_ders
tinglers93710573tinglers
tinkers113517143tin_kers
tinklers12298183tinklers
tinners73717303tin_ners
tinters74221103tin_ters
tithers104216733ti_thers
tochers123413093_tochers
touchers133611203touchers
trenchers14288073trenchers
twiners10459633twin__ers
twinklers1633063twinklers
twitcher16135343twitcher_
twitches16156373twitche_s
vintners1134563vintners
vouchers16418623vouchers
wanders114221333wan_ders
wanglers123310033wanglers
wankers144514713wan_kers
wanters104420093wan_ters
washers134517523w_ashers
watcher153113403watcher_
watches153017373watche_s
weathers143412833weathers
weighers15135673weighers
weiners103913063wein__ers
welcher15319393welcher_
welches153710313welche_s
welshers14246813welshers
wenched163910913wenche_d
wethers135214693w_ethers
whackers20326543whackers
whickers20297983whickers
whinchats2042783whinchats
whiners134011573whin__ers
whingers15358713whin_gers
wicker154518673wi_cker_
wickets164010943wi_ckets
widders123512263wi_dders
wideners12257993wideners
widowers1535113widowers
wielders12196613wielders
wieners103212483wi_eners
wigglers13257203wigglers
wilders113513503wi_lders
willers103517903wi_llers
wince105220883winc_e__
winced124415343winc_e_d
wincey144110383winc_e_y
winch135016663winch___
winching17359903winching
winder104025263win_der_
windhovers2042213windhovers
windier113412163windier_
windles113518493windle_s
windless123310863windless
wineless112711173wineless
winery125014273win__ery
wines85546863win__e_s
wingchairs1951463wingchairs
winger104125433win_ger_
wingier113413273wingier_
wingless122910023wingless
winglets12299593winglets
wingovers1643543wingovers
winier94522453win_ier_
winker134220293win_ker_
winkles143412773winkle_s
winless103212283win_less
winner94219923win_ner_
winnowers1543943winnowers
winoes94317013win_oe_s
winter94222803win_ter_
winterers12209723winterers
wintery13399743win_tery
wintles103414983wintle_s
winzes184313053win_ze_s
wipers115416083wi__pers
wirers94617893wi__rers
wisher123617063wi_sher_
wishes124920953wi_she_s
witched163012193witche_d
witcheries1845463witcheries
witchier16307883witchier_
wither124321353wi_ther_
withes124620843wi_the_s
wivers125320803wi__vers
wonders113315993won_ders
wonners104312813won_ners
wreckers17315973wreckers
wrencher16287783wrencher_
wrenches163210233wrenche_s
wringers123110073wrin_gers
writhers14398983writhers
wuthers133711523w_uthers
wyches17387913w_yche_s
zilches21326303zilche_s
zingers173514843zin_gers
zithers193911973zi_thers

Search took 9 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.1731032896.0
2DLD Change Limit1461623437.90318494.5
3Display Results3433430.2661289.5
 (SQL Overall)1786913438.34221420.6
 
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.