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

186 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
volante103851(None) 
volant9316321volant_
folate93320392fola_te
solate64526072sola_te
tolane64316582tolan_e
valance1269252valance
velate93720142vela_te
violate10311552viola_te
volte85321302vol__te
volute93912762vol_ute
volvate13317992volvate
ablate82219213abla_te
alane56135613_alan_e
alant55742293_alant_
alants67722023_alants
alate55340333_ala_te
allanite8411093allanite
andante8311273andante
ante46538903___ante
aslant6317753aslant_
atlantes838553atlantes
balance11510263balance
blate75933783_bla_te
bolete8519613bol_ete
borane84620213boran_e
borate85026153bora_te
cholate122114933chola_te
cognate10312203cognate
colander1139033colander
collate92919683collate
colone85425003colon_e
comate104124843coma_te
connate9315753connate
conte76633203co__nte
coolant9316463coolant_
coolants1039943coolants
coranto9311893coranto
courante1049953courante
delate73827753dela_te
dilate73220693dila_te
donate73619503dona_te
dopant9316133dopant_
dopants1038433dopants
elate55335883_ela_te
evolute1045683evol_ute
flange103411973_flange
folates103218453fola_tes
foliate10513533foliate
gelant72821673gelant_
gelants82611443gelants
gelate73421263gela_te
glance94312313_glance
infante101910883infante
iodate7313503ioda_te
iolite63221983iol_ite
isolate7313923isola_te
joyance1944773joyance
kokanee1044803kokanee
lanate6421263__lanate
lance75126723__lance
lane45153333__lan_e
late47560483__la_te
latte55426303__latte
lobate82915243loba_te
locate83919843loca_te
malate84624563mala_te
melange1038363melange
melanite10512033melanite
moline84422033molin_e
monte75829773mo__nte
notate63217863nota_te
oblate82214743obla_te
oleate6318883_oleate
oolite63319603ool_ite
orange74016323_orange
orate55133303_ora_te
ornate6315143_ornate
ovate84214393_ova_te
ovulate1039453ovula_te
palate84226793pala_te
parlante1039693parlante
picante11310523picante
planate9314573_planate
plane74929143_plan_e
planet84228353_planet
plant75437113_plant_
planted103516123_planted
planter94017803_planter
plants84921803_plants
plate74635113_pla_te
pointe84619313po_inte
polenta9310093polenta
polite83625073pol_ite
pollute937383pollute
prolate9419793prola_te
relate64033633rela_te
rolamite1048743rolamite
romance11311083romance
rotate63320343rota_te
silane62718053silan_e
slainte738543_slainte
slant55238703_slant_
slanted83514743_slanted
slants64819083_slants
slanty95114843_slanty
slate55438283_sla_te
solace83415823sola_ce
solan55328153solan__
soland75115043solan_d
solander948123solander
solands84412343solands
solanin7311943solanin
solanine8311533solanine
solano65314183solan_o
solanos74412853solanos
solans64122493solan_s
solanum946403solanum
solated83618023sola_ted
solates73523853sola_tes
solute64016663sol_ute
solvate102710213solvate
sonance9310313sonance
sonant6621953sonant_
sonants7511233sonants
togate74515683toga_te
tolan55124013tolan__
tolanes74216313tolanes
tolans64319273tolan_s
toluate7159343toluate
vacant11415133vacant_
vacate11314553vaca_te
valanced1475463valanced
valances1398763valances
valence1268773valence
valiance1397383valiance
valiant10314623valiant_
valiants1137793valiants
valine94623093valin_e
vallate103016563vallate
valuate102512733valuate
valvate133710813valvate
vane75534693v__an_e
veloute1037733veloute
vigilante1343633vigilante
vilayet1348533vilayet
violable1337543violable
violated1237883viola_ted
violater1137253viola_ter
violates11311193viola_tes
violence1345713violence
violent102110813violent_
violone1037153violon_e
vocable14189673vocable
voidance1444723voidance
volar86917413vola__r
volatile1146433volatile
volcanic1544773volcanic
volcanize2345733volcanize
volcano1244613volcan_o
volcanoes1443783volcanoes
volcanos1344733volcanos
vole75236983vol___e
voling103918023volin_g
volitant1147863volitant_
volost9412643volost_
volosts1036563volosts
volplane1344313volplan_e
volt76439533vol__t_
volta85215623vol__ta
voltage1136863voltage
voltes94915583vol__tes
volti84915963vol__ti
volts85421293vol__ts
voluble1244503voluble
volume11358273vol_ume
volunteer1241983volunteer
voluted11297943vol_uted
volutes102710983vol_utes
vorlage1136403vorla_ge
votable122111373votable
vote74728623vo___te
voyage1335473voya_ge
vulcanite1444713vulcanite
vulgate11388433vulgate
vulvate13388323vulvate
zonate154114923zona_te

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271866.03022226.7
3Display Results1861860.0802325.0
 (SQL Overall)1786911866.51627423.4
 
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.