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

179 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
vaginae1137768(None) 
vagina102710931vagina_
vaginal11288401vaginal
vaginas11298811vaginas
vaginate123911081vaginate
carinae94318592carinae
evaginate1376482evaginate
laminae93512972laminae
paginal10269492paginal
paginate114012442paginate
patinae95414402patinae
reginae84713452reginae
vagile10310542vagi_le
vaginated14328152vaginated
vahine123612112vahin_e
valine94623092valin_e
acinar8310483_acinar
agapae9388043_agapae
agene65621583_agen_e
agile65122263_agi_le
agin56132713_agin__
aging77026353_agin_g
agings86312673_agings
aginner844663_aginner
agita6315423_agita_
agitas7310593_agitas
agitate8312063_agitate
agminate1139243_agminate
agnate73314883_ag_nate
agnize16329563_agnize
agonal7410053_agonal
agone65924553_agon_e
agorae7511203_agorae
alginate9310693alginate
aline57243153_alin_e
amine75835383_amin_e
angina7413133angina_
anginal8310163anginal
anginas8310953anginas
arginase946443arginase
azine146721413_azin_e
badinage1294923badinage
basinal9310033basinal
caging105321023cagin_g
canine83826703canin_e
carina84325333carina_
carinal94318243carinal
carinas93622413carinas
carinate103320253carinate
catenae9311373catenae
engine71114863engin_e
evaginated1575133evaginated
evaginates1475993evaginates
faciae112913413faci_ae
fagin9216573fagin__
fagins10513863fagin_s
famine114318193famin_e
farina94618233farina_
farinas103215243farinas
faunae95210373fa_unae
gaging94718403gagin_g
gamine94620153gamin_e
imaginal1144903imaginal
imagine1037883imagin_e
invaginate1445053invaginate
jarina134014063jarina_
jarinas143712193jarinas
lacunae9116803lacunae
laguna7127223laguna_
lagunas8156823lagunas
lagune7158633lagun_e
lamiae84817453lami_ae
lamina84920443lamina_
laminal94113633laminal
laminar93810283laminar
laminas93615873laminas
laminate103014633laminate
larine63927043larin_e
latina65621143latina_
latinas74416463latinas
lawine93316463lawin_e
magian9312833magi_an
magians10310753magians
magical1239783magical
magnate10512703mag_nate
maline84529083malin_e
marginal1137613marginal
marginate12179603marginate
marina84623413marina_
marinade11259383marinade
marinas93519393marinas
marinate103017783marinate
marine84230403marin_e
matinal9312603matinal
matinee92415613matinee
minae75627723__minae
nagana748943nagana_
naganas847983naganas
narine63422553narin_e
paginated13309463paginated
paginates123111363paginates
paging104020403pagin_g
pagings114411063pagings
patina86022193patina_
patinaed11407833patinaed
patinas96318523patinas
patinate103016313patinate
patine85328123patin_e
raging85126433ragin_g
rapine85023083rapin_e
ratine65131823ratin_e
ravine95522223ravin_e
regina75317143regina_
reginal84814293reginal
reginas85614063reginas
retinae75517333retinae
sabine84020393sabin_e
salina64221123salina_
salinas73116093salinas
saline65132703salin_e
sarcinae1047193sarcinae
savine94220283savin_e
taeniae739083taeniae
tagline82412453taglin_e
vaccina1435303vaccina_
vaccinal1544903vaccinal
vaccinas1544973vaccinas
vaccinate1646833vaccinate
vaccine1437323vaccin_e
vaccinee1544853vaccinee
vagal94613633vag__al
vagi86719363vagi___
vaginally1645233vaginally
vaginoses1344143vaginoses
vagrant11410663vagrant
vague96513113vag__ue
vahines133410523vahines
vain75233003va_in__
vainer93714573va_iner
vainly1258503va_inly
valance1269253valance
valence1268773valence
valiance1397383valiance
valiant10314623valiant
validate1239003validate
valines104520213valines
valise92917643vali_se
vane75534693va__n_e
varia85824203vari_a_
variance1397413variance
variant10316803variant
varias95019903vari_as
variate101316433variate
variole10711593variole
varna84516173va_rna_
varnas94212823va_rnas
vatical1239983vatical
vegie94614513vegi__e
veinal93812963v_einal
venae85920983v__enae
venine93718433venin_e
vesicae12177703vesicae
vicinage1444003vicinage
vicinal12268543vicinal
vigia94813273vigi_a_
vigias104110893vigi_as
vimina11339943vimina_
viminal12288823viminal
vina76331803v__ina_
vinal85725813v__inal
vinas85126343v__inas
vine75643683v__in_e
virginal1244573virginal
vitae84217633v__itae
vogie95116663vogi__e
vomicae1445303vomicae
waging114318383wagin_g
wagonage1343293wagonage
wahine123813013wahin_e

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 Limit1340271796.46620728.0
3Display Results1791790.0632841.3
 (SQL Overall)1786911796.93525766.5
 
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.