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

178 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
vulgate1138843(None) 
vulgates12237231vulgates
vulvate13388321vulvate
bullate93415072bullate
divulgate1463102divulgate
jugate14379462ju_gate
ovulate1039452ovul_ate
pulsate9510232pulsate
rugate75813812ru_gate
sulcate9314422sulcate
sulfate10311652sulfate
vallate103016562vallate
valuate102512732valuate
valvate133710812valvate
velate93720142vel_ate
virgate1138732virgate
volvate13317992volvate
vulgar10426822vulga_r
vulgarer1243012vulgarer
vulgars11306532vulgars
vulvae12438032vulva_e
ablate82219213abl_ate
ablegate1147253ablegate
aculeate1039923aculeate
adulate8313233adul_ate
agate66525153__agate
alate55340323_al_ate
algae65319623_alga_e
augite7312613au_gite
aurate64426473au_rate
aureate72515283aureate
blate75933783_bl_ate
bulge86419873bulg__e
bulkage1435703bulkage
bullace113410673bullace
bullae83416163bulla_e
burgage1136633burgage
bursate94111203bursate
ciliate9514603ciliate
collate92919683collate
culotte976893culotte
culpae10389263culpa_e
cultrate10310873cultrate
cuneate9311723cuneate
curate85226243cu_rate
curtate9312643curtate
cuspate1138233cuspate
delate73827753del_ate
delegate10410463delegate
dilate73220693dil_ate
divulgated1662683divulgated
divulgates1562933divulgates
elate55335883_el_ate
eluate62315433_eluate
emulate9314123emul_ate
ergate7315143_ergate
evaluate11287793evaluate
falcate12311613falcate
fellate10313433fellate
filiate10414233filiate
fluxgate1942893fluxgate
folate93320393fol_ate
foliate10513533foliate
frigate11311063frigate
fugato1036223fu_gato
fulgurate1344063fulgurate
fumigate1446153fumigate
furcate12310453furcate
galeate83916783galeate
gallate83417123gallate
gate55746573___gate
gelate73421253gel_ate
guttate8328903guttate
humate113214443hu_mate
ingate73018243_ingate
late47560483__l_ate
legate72917453_legate
ligate72519253_ligate
luggage1043673luggage
lunate6316043lu_nate
luxate1338083lu_xate
malate84624553mal_ate
maleate94117543maleate
mullite9313013mullite
muriate9313363muriate
mutate83017483mu_tate
negate72915573_negate
nucleate1048673nucleate
nutate63017373nu_tate
oblate82214743obl_ate
obligate11198303obligate
oleate6318883_oleate
outate62923403ou_tate
outdate83016423outdate
outgave11259563outgave
outgaze17239223outgaze
outrate72323183outrate
ovulated1237083ovul_ated
ovulates1148523ovul_ates
palate84226783pal_ate
paleate94120003paleate
palmate113215233palmate
palpate113213923palpate
peltate92013773peltate
pileate93815923pileate
plate74635113_pl_ate
plumate1149803plumate
pulsated1136853pulsated
pulsates1048813pulsates
pupate104213123pu_pate
quate144521413qu__ate
quinate16511573quinate
relate64033633rel_ate
relegate9311243relegate
rugae65114763ru_ga_e
ruinate7312833ruinate
runagate944293runagate
slate55438283_sl_ate
solate64526073sol_ate
solvate102710213solvate
soulmate1047193soulmate
sublate9315363sublate
sulcated11310373sulcated
sulfated1238833sulfated
sulfates11310793sulfates
sulfite10310473sulfite
sullage859913sullage
sulphate1346643sulphate
summate113611663summate
tailgate946823tailgate
togate74515683_togate
tollgate946253tollgate
toluate7159343toluate
tubate82813173tu_bate
turgite837973turgite
ullage739043_ullage
ulnae55214573_ulna_e
ululate749963_ululate
ungated92717213_ungated
update93810293_update
upgaze1833543_upgaze
uprate83916543_uprate
urate55432163_u_rate
uvulae945323uvul_a_e
vacate11314553v_acate
valerate11311473valerate
validate1239003validate
valuated12239203valuated
valuates112811203valuates
variate101316433variate
vegete1039483v_egete
veloute1037733veloute
vibrate122811523vibrate
villae95615383villa_e
village113610833village
violate10311553violate
virgates1237923virgates
vitiate103412953vitiate
vittate10409733vittate
volante1038513volante
voltage1136863voltage
volte85321303vol__te
volute93912763vol_ute
vulcanite1444713vulcanite
vulgarest1343773vulgarest
vulgarise13495993vulgarise
vulgarity1693993vulgarity
vulgarize22135433vulgarize
vulgarly1543163vulgarly
vulgo936953vulg__o
vulgus1035783vulg_us
vulguses1243503vulguses
vulpine1235903vulpine
vulture1036763vulture
vulva11448803vulva__
vulval12417663vulva_l
vulvar12427963vulva_r
vulvas12388843vulva_s

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.410435831.7
2DLD Change Limit1340271785.56024105.6
3Display Results1781780.0802225.0
 (SQL Overall)1786911786.05029535.7
 
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.