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

184 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
vulvae1243803(None) 
vulva11448801vulva_
vulval12417661vulval
vulvar12427961vulvar
vulvas12388841vulvas
vulvate13388321vulvate
bullae83416162bullae
culpae10389262culpae
silvae92811092silvae
sylvae12236862sylvae
ulnae55214572_ulnae
ulva75412692_ulva_
ulvas84511502_ulvas
uvulae945322uvul_ae
valval12398862valval
valvar12388652valvar
valvate133710812valvate
valve114515932valv_e
villae95615382villae
volva11399002volva_
volvas12447992volvas
volvate13317992volvate
vulgar10426822vulgar
vulgate11388432vulgate
alae45643753_al_ae
algae65319623_algae
alulae6312743alulae
aurae54128113au_rae
avulse935843avul_se
blae66134643_bl_ae
bulbar1039583bulbar
bulge86419873bul_ge
bulkage1435703bulkage
bulla74620563bulla_
bullace113410673bullace
bullate93415073bullate
bursae84515603bursae
calve105919923calv_e
cellae84915933cellae
clave105420153_clave
cullay113910173cullay
culpa93610963culpa_
culver113010633culver
curiae84518373curiae
curve104920023curv_e
cuvee10316143cu_vee
delve96018263delv_e
dulia61014983dulia_
dulias71212743dulias
dulse65415043dul_se
evolve12306503evolv_e
evulse935213evul_se
fulham1435303fulham
fullam1138363fullam
fulmar1137253fulmar
galeae74717453galeae
guava938583guava_
guavas1037153guavas
gulag7310823gul_ag
gular6314833gul_ar
guttae73210583guttae
halva115414433halva_
halvah15499833halvah
halvas124714173halvas
halve114818923halv_e
helve115018093helv_e
hula74923753hul_a_
hulas84920883hul_as
humvee1439203humvee
kulak858823kul_ak
larvae938843larvae
lave75642143__lave
mule65236973mul__e
mulla74317113mulla_
mullah113710733mullah
mullas84215933mullas
muscae10410673muscae
novae85913123_novae
nuchae11218513nuchae
nullah9388143nullah
outvie92412793outvie
ovular946833ovul_ar
ovulate1039453ovulate
ovule839493ovul__e
paleae84820293paleae
pula65129373pul_a_
pule65040953pul__e
pulpal10408453pulpal
pulque1736213pulque
pulsar8329363pulsar
pulsate9510233pulsate
pulse74219973pul_se
pupae96515643pu_pae
rugae65114763ru_gae
rule49938423rul__e
salpae84614273salpae
salvage1138193salvage
salve85022133salv_e
selva83014273selva_
selvage1136553selvage
selvas93812913selvas
silva82714023silva_
silvan92810153silvan
silvas92912183silvas
slave84224033_slave
solvate102710213solvate
solve85618943solv_e
suave83519873suav_e
sulcal8311273sulcal
sulcate9314423sulcate
suldan72611043suldan
sulfa8313923sulfa_
sulfas9311563sulfas
sulfate10311653sulfate
sullage859913sullage
sultan63012593sultan
summae103911013summae
sundae7312873sundae
sylva11268443sylva_
sylvan12257363sylvan
sylvas12288173sylvas
telae54323293tel_ae
tubae74716643tu_bae
tule45735873tul__e
tulle54019933tul_le
ulan46527393_ul_an
ullage739043_ullage
ulna46317323_ulna_
ulnad65611453_ulnad
ulnar56013983_ulnar
ulnas55716533_ulnas
ulpan7310123_ulpan
ursae55214453_ursae
uvea74712653_u_vea
uvula845153uvul_a_
uvular955563uvul_ar
uvulas946523uvul_as
vale74937343val__e
valine94623093valine
valise92917643valise
vallate103016563vallate
valse85117523val_se
valuate102512733valuate
value85719093val_ue
valved136711043valved
valves124113783valves
valvulae1442723valvulae
valvule1343663valvule
varve115716853varv_e
vela75725543vel_a_
velar85817633vel_ar
velate93720143velate
veloce11310133veloce
velure939773velure
velvet123613753velvet
venae85920983v_enae
verve115417723verv_e
vile76139803vil__e
villa85321233villa_
village113610823village
villas96117263villas
vitae84217633v_itae
vittae93910993vittae
viva106119093v_iva_
vivace1436553v_ivace
vivas114815023v_ivas
vive105426623v_iv_e
volar86917413vol_ar
vole75236983vol__e
volta85215623volta_
voltage1136863voltage
volte85321303vol_te
volume11358273volume
volute93912763volute
volvox1933363volvox
vulgarer1243013vulgarer
vulgars11306533vulgars
vulgates12237233vulgates
vulgo936953vul_go
vulgus1035783vulgus
vulpine1235903vulpine
vulture1036763vulture
yulan8411493yul_an
yule75725143yul__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 Filter1786911127160.186960704.3
2DLD Change Limit1127161846.31317854.6
3Display Results1841840.0464000.0
 (SQL Overall)1786911846.54527301.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.