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

252 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
vintners113457(None) 
vintner1034831vintner_
centners1057242centners
dinners83915442din_ners
ginners84314222gin_ners
hinters103719582hint_ers
inners63919352_in_ners
inters64328052_int_ers
intoners889932_intoners
linters73822632lint_ers
minters93822472mint_ers
pinners93518602pin_ners
sinners74019022sin_ners
sinters74024082sint_ers
tinners73717312tin_ners
tinters74221112tint_ers
vanners103612842van_ners
venters103717732vent_ers
vintagers13123902vintagers
winners104316912win_ners
winters103720482wint_ers
aginners954623agin_ners
anthers103715203_anthers
antlers74014743_antlers
banners94018713ban_ners
banters94623113bant_ers
binders103920743bin_ders
biners85023633bi__ners
bingers104519993bin_gers
bisters93922613bist_ers
biters83925243bi_t_ers
bitters94920363bi_tters
bunters94717123bunt_ers
canners93822663can_ners
canters94827733cant_ers
centers94420603cent_ers
centner946853centner_
cinders104617763cin_ders
citers85022983ci_t_ers
cithers124315773ci_thers
cointers103616413coint_ers
conners94023113con_ners
cunners93913473cun_ners
dieters83216433diet_ers
diethers1257453diethers
diners75525953di__ners
dingers94321383din_gers
dinner74217163din_ner_
dithers114016153di_thers
diviners12308353diviners
enters64425643_ent_ers
fainters11349693faint_ers
faintness1235833faintness
fanners103914653fan_ners
filters103816553filt_ers
finders113717873fin_ders
fineness11310643fineness
fingers113418433fin_gers
fitness10299393fi_tness
fitters104517753fi_tters
gingers94118643gin_gers
ginner73915823gin_ner_
grinners9288043grin_ners
gunners83111733gun_ners
hinders113718503hin_ders
hingers113420213hin_gers
hinter94021303hint_er_
hitters104717593hi_tters
hunters103915733hunt_ers
inaner62213543_inaner_
inanes62519803_inane_s
inchers123912523_inchers
infers93615443_in_fers
inkers104018833_in_kers
inliers73110743_inliers
inner54920633_in_ner_
integers937783_integers
intenders10219373_intenders
intends8239963_intends
intents72115703_intents
inter55028493_int_er_
intern64016543_int_ern
interns73116773_int_erns
intines7921113_intine_s
intoner7811673_intoner_
intones7816543_intone_s
ironers74813553_ironers
jilters144211963jilt_ers
jinglers16408763jinglers
jinkers183511813jin_kers
jitneys17313173ji_tneys
jitters144314473ji_tters
jointers15289323joint_ers
kilters113813603kilt_ers
kindlers13318483kindlers
kindness13236653kindness
kiters105218593ki_t_ers
knitters12336623knitters
lanners73618333lan_ners
lifters104313783lift_ers
limners93311563li_mners
liners65428853li__ners
lingers84223303lin_gers
linkers114317713lin_kers
linnets739833lin_nets
lintels73311163lint_els
linter64625343lint_er_
lintier73613803lintier_
lintless82710013lintless
listeners9147323listeners
listers74026533list_ers
liters65429883li_t_ers
litters73422573li_tters
liveners11217933liveners
manners93417833man_ners
milters93619093milt_ers
mincers113714853min_cers
minders103720123min_ders
miners84126633mi__ners
minglers113011293minglers
minivers1337483minivers
minsters103813923minsters
minter84425103mint_er_
mintier93615993mintier_
misters93927513mist_ers
miters84328783mi_t_ers
mithers123516733mi_thers
niters64624213ni_t_ers
painters103013023paint_ers
panners93621273pan_ners
panthers13510783panthers
partners102711133partners
penners93414183pen_ners
pilsners1035533pilsners
pincers113916503pin_cers
pinchers153510613pinchers
pinders103720473pin_ders
pinenes93416673pinene_s
pingers104020743pin_gers
pinkers134118603pin_kers
pinkness1436513pinkness
pinner84521503pin_ner_
pinones94717073pinone_s
pintles94118723pintle_s
pintoes95117713pintoe_s
pitiers93812653pi_tiers
pointers103013723point_ers
printers103214903print_ers
punners94114233pun_ners
punters93617043punt_ers
qintars16268573qint_ars
ranters73323643rant_ers
reinters82614773reint_ers
renters74224813rent_ers
rentiers83311763rentiers
ringers83922953rin_gers
rinsers73815743rin_sers
rioters73615513riot_ers
ripeners1036833ripeners
ritters74020623ri_tters
runners74212453run_ners
sifters103714793sift_ers
signers84714443si_gners
singers83824703sin_gers
sinkers113618543sin_kers
sinner64320603sin_ner_
sinter63625923sint_er_
sisters73721593sist_ers
sitters74221553si_tters
skinners12347293skin_ners
spinners103810863spin_ners
stinters83312753stint_ers
tanners74018393tan_ners
tenners74014923ten_ners
tenoners858713tenoners
tenters73921103tent_ers
thinners11327753thin_ners
tilters73315953tilt_ers
tinders84219173tin_ders
tinglers93710593tinglers
tininess8310633tininess
tinkers113517143tin_kers
tinklers12298183tinklers
tinner64119963tin_ner_
tinter63923643tint_er_
tintless8239863tintless
titers64526413ti_t_ers
titfers10318933ti_tfers
tithers104216733ti_thers
titters74219623ti_tters
tonners73816403ton_ners
uniters73814173unit_ers
vainness1136063vain_ness
vanner94215843van_ner_
vastness11257293vastness
vaunters11327753vaunt_ers
veiners104112523v_einers
venders113717003ven_ders
veneers103710293ven_eers
venenes102712133venene_s
venines103516613venine_s
venomers1336703venomers
venter94218723vent_er_
ventless11249053ventless
venturers1245523venturers
ventures11311493ventures
vetoers10359473v_etoers
vetters104016323v_etters
viatores11257683viatores
viators102712023viat_ors
victors123311183vict_ors
victress1344523victress
viers85621953vi___ers
viewers1337173vi_ewers
vignetters1442453vignetters
vileness1139983vileness
vinegars1245063vinegars
vinery124912603vi__nery
vines85137643vi__ne_s
vinier93716743vin_ier_
vinifera1443453vinifera
viniferas1542843viniferas
vintager12104823vintager_
vintages12118273vintages
vipers114914533vi__pers
virtues10338023virtue_s
visiters1137413visiters
vitamers1334683vitamers
vittles103211113vittle_s
vivers124717363vi__vers
viziers19336203vi_ziers
voters95017443v_ot_ers
wanters104420093want_ers
wantoners12116673wantoners
wideners12257993wideners
wieners103212483wi_eners
wincers123415363win_cers
winchers16319223winchers
winders113721263win_ders
wingers113921483win_gers
winkers143517113win_kers
winner94219933win_ner_
winter94222803wint_er_
winterers12209723winterers
wintery13399753wint_ery
wintles103414983wintle_s
withers134417753wi_thers
witness103010013wi_tness
witneys13274723wi_tneys
wonners104312813won_ners
zingers173514853zin_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.470380193.6
2DLD Change Limit1461622527.83018666.9
3Display Results2522520.0932709.7
 (SQL Overall)1786912528.39321290.5
 
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.