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

143 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
vulgates1223723(None) 
vulgate11388431vulgate_
divulgates1562932divulgates
ovulates1148522ovul_ates
pulsates1048812pulsates
sulfates11310792sulfates
valuates112811202valuates
virgates1237922virgates
vulgarer1243012vulgarer
vulgarest1343772vulgarest
vulgars11306532vulga_rs
vulguses1243502vulguses
vulvate13388322vulvate_
ablates92416903abl_ates
ablegates1246793ablegates
adulates9311913adul_ates
agates76121343__agates
alates64833963_al_ates
augites8312183au_gites
bulges95919323bulg__es
bulkages1535273bulkages
bullaces12299433bullaces
bullate93415073bullate_
burgages1236483burgages
ciliates10413453ciliates
collates103019143collates
culottes1076293culottes
curates95323833cu_rates
delates83526283del_ates
delegates1139843delegates
dilates83220663dil_ates
divulgate1463103divulgate_
divulgated1662683divulgated
elates65032363_el_ates
eluates72014683_eluates
emulates10312573emul_ates
ergates8314493_ergates
evaluates12247353evaluates
fellates11312753fellates
filiates11412663filiates
fluxgates2042763fluxgates
folates103218453fol_ates
foliates11412753foliates
frigates12310933frigates
fugatos1135483fu_gatos
fulgurates1453623fulgurates
fumigates1545573fumigates
furcates1339883furcates
gallates92815523gallates
gates65939513___gates
gelates83219583gel_ates
humates122813193hu_mates
ingates82716913_ingates
jugate14379463ju_gate_
legates82917683_legates
ligates82318383_ligates
luggages1143633luggages
luxates1436973lu_xates
malates93522603mal_ates
maleates103316343maleates
mullites10411643mullites
muriates10312083muriates
mutates92215793mu_tates
negates83215843_negates
nucleates1148563nucleates
nutates73214973nu_tates
oblates91913243obl_ates
obligates12207853obligates
oleates7417833_oleates
outdates93114743outdates
outgazes18248713outgazes
outrates82421373outrates
ovulate1039453ovul_ate_
ovulated1237083ovul_ated
palates93624933pal_ates
palpates122613063palpates
plates85432243_pl_ates
pulsate9510233pulsate_
pulsated1136853pulsated
pupates113311433pu_pates
relates73731433rel_ates
relegates10310943relegates
rugate75813813ru_gate_
ruinates8311883ruinates
runagates1044333runagates
slates64934063_sl_ates
solates73523853sol_ates
solvates11249673solvates
soulmates1147073soulmates
sublates10315003sublates
sulcate9314423sulcate_
sulcated11310373sulcated
sulfate10311653sulfate_
sulfated1238833sulfated
sulfites1139903sulfites
sullages939973sullages
sulphates1466163sulphates
summates122610493summates
tailgates1046533tailgates
tollgates1046053tollgates
toluates8138903toluates
turgites937783turgites
ullages838953_ullages
ululates848433_ululates
ungated92717213_ungated
updates10329793_updates
upgazes1933573_upgazes
uprates93814863_uprates
urates65027763_u_rates
vacates12312833v_acates
valerates12310543valerates
valguses1234233valguses
validates1338243validates
vallate103016563vallate_
valuate102512733valuate_
valuated12239203valuated
valvate133710813valvate_
variates111214983variates
velate93720143vel_ate_
velites103417303vel_ites
veloutes1136153veloutes
vibrates132210613vibrates
villages123010603villages
violates11311193violates
virgate1138733virgate_
vitiates112311433vitiates
voltages1237253voltages
voltes94915583vol__tes
volutes102710983vol_utes
volvate13317993volvate_
vulcanites1544483vulcanites
vulgar10426823vulga__r
vulgarise13495993vulgarise
vulgarises14135493vulgarises
vulgarism15145143vulgarism
vulgarities1544073vulgarities
vulgarizes23145203vulgarizes
vulgarly1543163vulgarly
vulgus1035783vulg__us
vultures1137213vultures
vulvae12438033vulva_e_
vulvas12388843vulva__s
vulvitis1442923vulvitis

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 Limit1461621436.26323337.4
3Display Results1431430.0632269.8
 (SQL Overall)1786911436.48227567.3
 
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.