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

261 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
wineries11231653(None) 
fineries112416741fineries
pineries102419081pineries
vineries112716041vineries
binaries10314182binaries
binderies12311682binderies
cinerins10414102cinerins
joineries1648102joineries
lingeries10511812lingeries
liveries11314372liveries
miseries10320402miseries
nineties8312912nineties
niteries8318382niteries
veneries112815032veneries
wienies102213682wi_enies
wiggeries14136572wiggeries
winterier1238332winterier
winteriest1348812winteriest
winterizes2247142winterizes
wintrier1136872wintrier
wintriest1238152wintriest
aeries64737783__aeries
amberies122514683amberies
anergies9310453_anergies
aperies9423203_aperies
arteries8321483arteries
bakeries14312193bakeries
beaneries11310903beaneries
bibberies1297133bibberies
biners85023633biner__s
boiseries11411043boiseries
boweries13312293boweries
briberies1348333briberies
canaries10318943canaries
canneries11313083canneries
celeries10316313celeries
cicelies1269753cicelies
cineoles10109403cineoles
cinerin9313823cineri_n
congeries12316403congeries
coteries10422703coteries
deaneries10310833deaneries
diaries83321953di_aries
dimerizes2167943dimerizes
dineric10310973dineri_c
dineros83812333diner_os
diners75525953diner__s
dinettes9310193dinettes
dinghies1347363dinghies
dingies93618243din_gies
dinkies123716033din_kies
dioecies1138933dioecies
diverges13258313diverges
doweries12411933doweries
duperies11312813duperies
eateries8324313eateries
emeries91620023_emeries
emperies12314563emperies
enemies9313693_enemies
energies9310783_energies
engineries1145473engineries
entries71523163_entries
faeries104118993_faeries
fakeries1559833fakeries
ferneries1239043ferneries
fiberizes2346173fiberizes
fierier103511193fi_erier
fieriest112112243fi_eriest
finesses111912343finesses
fisheries1548643fisheries
flaneries1249563flaneries
gantries91413783gantries
generics11118793generics
gentries91315263gentries
gingelies11277503gingelies
grinderies1245833grinderies
gunneries1047043gunneries
henneries1248643henneries
henries102718283hen_ries
hinnies103615103hin_nies
indies73822783_in_dies
indris7311963_indri_s
inertias8410383_inertias
inerts64517023_iner_ts
inheres10315173_inher_es
inherits11310103_inherits
injuries1567683_injuries
innerves1158013innerves
interims101013073_interims
internes82721233_internes
interties9320333_interties
inures63318953_inur_es
inverses112410983_inverses
ivories10310713_ivories
japeries17311463japeries
kineses113111253kine_ses
kinesics14286283kinesics
kinesis11259593kinesi_s
kinetics14207253kinetics
kinetins12228153kinetins
liberties1149203liberties
lienteries1047563lienteries
liernes739623li_ernes
lindies8416583lin_dies
lineages979183lineages
linearise946433linearise
linearises1046343linearises
linearizes1945733linearizes
linerless936333linerless
liners65428853liner__s
lingerie959203lingerie_
liveried1238733liveried
minerals10311373minerals
miners84126633miner__s
minifies13312903minifies
miniseries1246753miniseries
minnies93617363min_nies
monkeries15129913monkeries
moperies12313873moperies
naperies10313903naperies
nereis6315343__nereis
nerves94216193__nerves
newies91014073__newies
niceties10310863niceties
ninepins1045873ninepins
ninnies73713613nin_nies
niterie7313743niterie_
nunneries947113nunneries
onerier7311613_onerier
oneriest8313443_oneriest
ornerier846043ornerier
orneriest947403orneriest
orreries8310123orreries
panfries13149203panfries
pantries101817393pantries
peeries93623023_peeries
penuries10311663penuries
pierces113411193pi_erces
pieties9419223pi_eties
piggeries13107893piggeries
pinenes93416673pine_nes
pinkies133818263pin_kies
pinnies93318443pin_nies
piperines131610693piperines
poperies12316793poperies
printeries12410633printeries
queries16315873_queries
quinaries1857873quinaries
refineries1347063refineries
reveries112518513reveries
rifleries1247683rifleries
roperies10315763roperies
roseries8317313roseries
ruderies9311333ruderies
sceneries1149393sceneries
sentries81318053sentries
series64540973__series
shinneries1345713shinneries
siderites10410433siderites
signories10107853signories
spiceries1349313spiceries
spinneries1245733spinneries
sundries9312023sundries
swanneries1344363swanneries
synergies1345093synergies
tanneries9310423tanneries
tiderips1145383tiderips
tierces93710453ti_erces
tineids8337873tine_ids
turneries948493turneries
twinberries1652983twinberries
twiners10459633twiner__s
twinkies1535983twin_kies
unnerves1157273unnerves
urinaries949203urinaries
veeries102916893_veeries
vinifies1439873vinifies
vivaries1439263vivaries
voleries11313233voleries
waggeries14127463waggeries
wasteries121115343wasteries
wastries111212883wastries
waterier11312083waterier
wateriest12312233wateriest
wearies103020223w_earies
weenies102915093w_eenies
weepies122811743w_eepies
weiners103913063weiner__s
wernerites1344943wernerites
wheelies1437863wheelies
wheres125917433w_her_es
wherries14179023wherries
wherves16548053w_herves
whiners134011573whiner__s
whinnies14237273whin_nies
whirries14136693whirries
wicopies1545983wicopies
widdies123514033wi_ddies
wieners103212483wiener__s
wienie9229973wi_enie_
wifelier1434853wifelier
wifeliest1545883wifeliest
willies103920153wi_llies
wincers123415363wincer__s
winces114819113win__ces
winches154714373win_ches
windages1338263windages
winders113721263winder__s
windier113412163win_dier
windiest122213233win_diest
windles113518493win_dles
windpipes1743103windpipes
windrows1546163windrows
wineless112711173wineless
winepress1443633winepress
winery125014283winer__y
wines85546863win___es
winesaps1364553winesaps
wineskins1644213wineskins
winesops1374663winesops
wingers113921483winger__s
wingier113413283win_gier
wingiest123214283win_giest
wingtips1443253wingtips
winier94522453win__ier
winiest103419693win__iest
winkers143517113winker__s
winkles143412773win_kles
winners104316913winner__s
winoes94317013win__oes
wintered122111573winter_ed
winterer112110443winter_er
winterers12209723winterers
winterfed1644993winterfed
wintering13412363wintering
winterish1546643winterish
winterize2146923winterize
winterized2345713winterized
winters103720483winter__s
wintertides1544463wintertides
wintertimes1643903wintertimes
wintles103414983win_tles
wintrily1445373wintrily
wintriness1345543wintriness
winzes184313053win__zes
wipers115416083wiper__s
wirers94617893wirer__s
wires86034913wi__r_es
wirier94215553wi__rier
wiriest103816853wi__riest
wiselier1137363wiselier
wiseliest1237723wiseliest
wisterias1248103wisterias
witcheries1845463witcheries
witherites1645973witherites
withies133913543wi_thies
witnesses12219923witnesses
wiverns13366963wiver_ns
wivers125320803wiver__s
worries104117133w_orries
wries85827743w___ries

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 Filter1786911461620.423422437.4
2DLD Change Limit1461622616.31023163.5
3Display Results2612610.1102372.7
 (SQL Overall)1786912616.84326113.0
 
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.