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

195 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
volvate1331799(None) 
solvate102710211solvate
valvate133710811valvate
vulvate13388321vulvate
collate92919682collate
folate93320392fol_ate
foliate10513532foliate
oleate6318882_oleate
ovate84214392_o_vate
solate64526072sol_ate
solvated12237442solvated
solvates11249672solvates
toluate7159342toluate
vallate103016562vallate
valuate102512732valuate
velate93720142vel_ate
violate10311552viol_ate
volante1038512volante
voltage1136862voltage
volte85321302vol__te
volute93912762vol_ute
volva11399002volva__
volvas12447992volva_s
vulgate11388432vulgate
vulvae12438032vulva_e
ablate82219213abl_ate
alate55340323_al_ate
blate75933783_bl_ate
bloviate1384913bloviate
bolete8519613bol_ete
borate85026153bo_rate
bullate93415073bullate
cholate122114933chol_ate
ciliate9514593ciliate
clavate1238713clavate
cognate10312193cognate
collage102813753collage
collated113615063collated
collates103019133collates
colocate12313433colocate
comate104124843co_mate
connate9315753connate
cordate10315213cordate
costate94019273costate
couvade1335063couvade
delate73827753del_ate
dilate73220693dil_ate
dogvane1243853dogvane
donate73619503do_nate
elate55335883_el_ate
elevate101110373elevate
eluate62315433_eluate
evaluate11287793evaluate
evolute1045683evol_ute
evolvable1743383evolvable
evolve12306503evolv__e
falcate12311613falcate
fellate10313433fellate
filiate10414233filiate
folates103218453fol_ates
foliage1147533foliage
foliated1249913foliated
foliates11412753foliates
formate123115093formate
fossate10388603fossate
foveate1338363foveate
galeate83916783galeate
gallate83417123gallate
gelate73421253gel_ate
globate1057823globate
goliath1145933goliath
iodate7313503io_date
iolite63221983iol_ite
isolate7313923isol_ate
late47560483__l_ate
lobate82915243lo_bate
locate83919843lo_cate
lovage1037353lo_vage
lovat8321043lo_vat_
lovats939073lo_vats
malate84624553mal_ate
maleate94117543maleate
motivate1347693motivate
nervate1039523nervate
notate63217863no_tate
novae85913123no_va_e
oblate82214743_oblate
obovate1235463obovate
obviate1235783_obviate
oleates7417833_oleates
oolite63319603ool_ite
opiate8513463_opiate
orate55133303_o_rate
ornate6315133_ornate
outate62923403_outate
overate10620963overate
ovulate1039453ovulate
palate84226783pal_ate
paleate94120003paleate
palmate113215233palmate
palpate113213923palpate
peltate92013773peltate
pileate93815923pileate
plate74635113_pl_ate
poleaxe1656303poleaxe
polite83625073pol_ite
pollute937383pollute
private121513263private
prolate9419793prol_ate
pulsate9510233pulsate
relate64033633rel_ate
roseate7613453roseate
rotate63320343ro_tate
salivate11310013salivate
salvage1138193salvage
savate9313783_savate
selvage1136553selvage
silvae92811093silva_e
slate55438283_sl_ate
solace83415823sol_ace
solated83618023sol_ated
solates73523853sol_ates
solute64016663sol_ute
solvable1337473solvable
solve85618943solv__e
sorbate9311733sorbate
soulmate1047183soulmate
spoliate1039243spoliate
sulcate9314423sulcate
sulfate10311653sulfate
sylvae12236863sylva_e
sylvite13266353sylvite
toccate1138773toccate
togate74515683to_gate
tolane64316583tol_ane
tolerate8312323tolerate
tollage82610163tollage
tollgate946253tollgate
toluates8138893toluates
vacate11314553v_acate
valerate11311463valerate
validate1239003validate
valuated12239203valuated
valuates112811193valuates
valval12398863valva_l
valvar12388653valva_r
valve114515933valv__e
valvule1343663valvule
variate101316433variate
veloute1037733veloute
velvet123613753velvet_
velveted1533833velveted
velvets13326693velvets
velvety16304003velvety
vibrate122811513vibrate
villae95615383villa_e
village113610823village
violated1237883viol_ated
violater1137243viol_ater
violates11311183viol_ates
virgate1138733virgate
vitiate103412953vitiate
vittate10409723vittate
vivace1436553v_ivace
volant9316323vol_ant
volar86917413vol_a_r
volatile1146433vol_atile
volcano1244613volcano
vole75236983vol___e
volost9412643volost_
volosts1036563volosts
volplane1344313volplane
volt76439533vol__t_
volta85215623vol__ta
voltages1237253voltages
voltaic1245453voltaic
voltes94915583vol__tes
volti84915963vol__ti
volts85421293vol__ts
voluble1244503voluble
volume11358273vol_ume
voluted11297943vol_uted
volutes102710983vol_utes
volvox1933363volv_ox
volvoxes2142243volvoxes
volvuli1352083volvuli
vorlage1136403vorlage
vote74728623vo___te
voyage1335473vo_yage
vulgates12237233vulgates
vulva11448803vulva__
vulval12417663vulva_l
vulvar12427963vulva_r
vulvas12388843vulva_s
zonate154114923zo_nate

Search took 8 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.1561145455.1
2DLD Change Limit1340271956.89019452.4
3Display Results1951950.0633095.2
 (SQL Overall)1786911957.10925135.9
 
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.