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

197 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
vintages1211827(None) 
mintages111110511mintages
vantages12119021vantages
ventages12119761ventages
vintage11128141vintage_
vintager12104821vintager
vintagers13123891vintagers
incages103013882_incages
innages82911302_innages
intakes11310942_intakes
linages8813172lin_ages
lineages979182lineages
linkages1385952linkages
mintage101110122mintage_
montages111412182montages
sinkages1386852sinkages
tentages91011042tentages
unitages938272unitages
vantage11109892vantage_
ventage11109622ventage_
villages123010592villages
visages1138692vi_sages
voltages1237252voltages
wantages12109022wantages
windages1338262windages
advantages1552343advantages
agiotages1143773agiotages
anlages82414103_anlages
bandages12310633bandages
binges93923123bin__ges
blindages1343663blindages
bondages1237893bondages
cartages11313313cartages
centares102913893centares
chantages1546583chantages
clientages1342793clientages
coinages11310803coin_ages
cottages113310493cottages
cuttages11297223cuttages
dictates11311373dictates
dinges83825423din__ges
distaves12311393distaves
dotages92311793_dotages
driftages1453153driftages
dunnages10154933dunnages
ecotages1136973ecotages
encages103313783_encages
engages92912493_engages
enrages83114853_enrages
entases72816273_entases
finagles12237553fin_agles
finales104016013fin_ales
flotages1237153flotages
footages1239043footages
frontages13116183frontages
hinges105121023hin__ges
hostages122311693hostages
images91411453_i_mages
inanes62519803_in_anes
incage93513623_incage_
incaged114010443_incaged
incases93615973_incases
infares10313023_infares
ingates82716893_ingates
inhales10511863_inhales
inlaces92512903_inlaces
inmates92715763_inmates
innage73011573_innage_
instates81615823_instates
intagli845013_intagli
intake10510863_intake_
integer837993_integer
integers937783_integers
intines7921113_intines
intones7816533_intones
invades11118293_invades
kinases113511123kin_ases
linage7713403lin_age_
lindanes939163lindanes
lineage878983lineage_
linkage1295963linkage_
manages103418963man_ages
meltages1148243meltages
menages103615393men_ages
metages102714973_metages
milages103114403mi_lages
mileages11249693mileages
millages113212893millages
mirages102213533mi_rages
mispages13311183mispages
mistakes141213403mistakes
montage101211713montage_
montaged12107763montaged
montanes101114523montanes
nictates1039583nictates
nonages8313843non_ages
nontaxes1537853nontaxes
outages82317323_outages
pentanes10316073pentanes
pillages113012603pillages
pilotages1245503pilotages
pinnaces12268863pinnaces
pintadas11105063pintadas
pintadoes1295243pintadoes
pintados11105993pintados
pintails10310163pintails
pintanos10107553pintanos
pintas85021393pinta__s
pintles94118723pint_les
pintoes95117713pint_oes
pinwales1367963pinwales
pipages1289423pi_pages
pipeages1336423pipeages
portages112613223portages
postages112815323postages
potages102416423_potages
pottages112910453pottages
qintars16268573qinta_rs
restages92815763restages
rivages1138873ri_vages
rootages939093rootages
scutages1136503scutages
septages1168263septages
signages1037473signages
silages82514443si_lages
singes74326853sin__ges
sinkage1287263sinkage_
sinuates8310953sinuates
spinages11289293spin_ages
stages75629493__stages
syntagms1442723syntagms
syntaxes1843633syntaxes
tankages13217113tankages
tannages9228963tannages
tentage81010643tentage_
tillages93011243tillages
tinges74722323tin__ges
tintypes1343273tintypes
tinwares1137903tinwares
tonnages9187873tonnages
tunnages9195903tunnages
uintaites9136333uintaites
uncages103213773_uncages
unitage838993unitage_
upstages11147373upstages
vendaces1457183vendaces
venges104015143ven__ges
ventails1139823ventails
ventures11311483ventures
vestiges1238243vestiges
viatores11257673viatores
vibrates132210593vibrates
vicarages1574433vicarages
vicinages1544073vicinages
village113610823village_
villager12267503villager
villagers13296133villagers
vinals94716483vin_a_ls
vinas85126343vin_a__s
vinasse1044513vin_asse
vinasses1135703vinasses
vincas113912453vinca__s
vinegars1245063vinegars
vineries112716043vineries
vines85137643vin___es
vinifies1439873vinifies
vintner1034823vint_ner
vintners1134563vintners
violates11311183violates
viragoes1245233vi_ragoes
viragos1146713vi_ragos
virgates1237903virgates
virtues10338023virt_ues
visage1049083vi_sage_
visaged1235683vi_saged
vistaed1138013vista_ed
vistaless1254573vistaless
vistas94513273vista__s
vitae84217633vi_ta_e_
vitals94514303vi_ta_ls
vitamer1235473vi_tamer
vitamers1334673vi_tamers
vitiates112311413vitiates
vittae93910993vitta_e_
vittate10409723vittate_
vittles103211113vi_ttles
vivaces1536413vi_vaces
voltage1136863voltage_
vorlages1236033vorlages
voyages1435703v_oyages
waftages15105393waftages
wantage11119623wantage_
wastages12109753wastages
wattages12106783wattages
windage1237933windage_
wintles103414983wint_les
zincates1937733zincates

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.1561145455.1
2DLD Change Limit1461621976.00024360.3
3Display Results1971970.0802462.5
 (SQL Overall)1786911976.23628654.7
 
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.