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

192 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
vulval1241766(None) 
valval12398861valval
vulva11448801vulva_
vulvae12438031vulvae
vulvar12427961vulvar
vulvas12388841vulvas
pulpal10408452pulpal
sulcal8311272sulcal
ulva75412692_ulva_
ulvas84511502_ulvas
valvar12388652valvar
volva11399002volva_
volvas12447992volvas
vulgar10426822vulgar
vulvate13388322vulvate
algal66518223_algal
arval86017013_arval
audial7312993audial
aural54428963au_ral
bubal94218213bu_bal
buccal1248243buccal
bulbar1039583bulbar
bulbel104510683bulbel
bulbil10389573bulbil
bulbul10348073bulbul
bull65634873bul__l
bulla74620563bulla_
bullae83416163bullae
burial84117623burial
bursal84414823bursal
coeval1138893coeval
cull65929643cul__l
cullay113910173cullay
culpa93610963culpa_
culpae10389263culpae
culver113010633culver
cuneal8611513cuneal
curial84019153curial
curtal83914543curtal
cuspal1037883cuspal
dual55928173du__al
ducal84816423du_cal
ductal938993ductal
dulia61014983dulia_
dulias71212743dulias
dull56430443dul__l
dural64923893du_ral
eluvial1045853eluvial
fallal93612693fallal
filial93013253filial
fluvial1345363fluvial
fugal95613033fu_gal
fulfil1246423fulfil
fulham1435303fulham
full75229153ful__l
fullam1138363fullam
fulmar1137253fulmar
fungal10388733fungal
glial66715433_glial
guava938583guava_
guavas1037163guavas
gulag7310823gul_ag
gular6314833gul_ar
gull54828453gul__l
halal85623593hal_al
hallal94415563hallal
halva115414433halva_
halvah15499833halvah
halvas124714173halvas
hula74923753hul_a_
hulas84920883hul_as
hull75428783hul__l
ileal56118083_ileal
ilial55317843_ilial
jugal135612403ju_gal
jumbal1758463jumbal
jural125120483ju_ral
kulak858823kul_ak
larval948503larval
leal46043273__leal
lull44225763lul__l
luteal64411483luteal
molal75120343mol_al
mughal1236273mughal
mull65128803mul__l
mulla74317113mulla_
mullah113710733mullah
mullas84215933mullas
mural75225113mu_ral
mutual838503mutual
naval85315833_naval
nival84915773_nival
nuchal11218873nuchal
nucleal946693nucleal
null45125313nul__l
nullah9388143nullah
ogival1035873ogival
oval77119523__oval
ovular946833ovul_ar
paleal84716673paleal
palpal104112053palpal
plural839823plural
pluvial1245433pluvial
pula65129373pul_a_
pull64731663pul__l
pulsar8329363pulsar
pupal97616873pu_pal
quezal2435143quezal
rival85216503_rival
rugal65916093ru_gal
rural55821173ru_ral
salal55425703sal_al
selva83014273selva_
selvas93812913selvas
serval93913413serval
silva82714023silva_
silvae92811093silvae
silvan92810153silvan
silvas92912183silvas
suboval12216723suboval
suldan72611043suldan
sulfa8313923sulfa_
sulfas9311563sulfas
sultan63012593sultan
sural55931263su_ral
sylva11268443sylva_
sylvae12236863sylvae
sylvan12257363sylvan
sylvas12288173sylvas
telial65815363telial
tubal75517203tu_bal
tussal6288323tussal
ulan46527393_ul_an
ulna46317333_ulna_
ulnad65611453_ulnad
ulnae55214573_ulnae
ulnar56013983_ulnar
ulnas55716533_ulnas
ulpan7310123_ulpan
ureal56722683_ureal
urial54823023_urial
usual5310183_usual
uveal84411073_uveal
uvula845153uvul_a_
uvulae945323uvul_ae
uvular955563uvul_ar
uvulas946523uvul_as
vagal94613633v_agal
valvate133710813valvate
valve114515933valv_e
valved136711043valved
valves124113783valves
valvula1343253valvula
valvule1343663valvule
vandal103713833vandal
vasal85516293v_asal
vassal979243vassal
veal76936813v__eal
veinal93812963veinal
vela75725543vel_a_
velar85817633vel_ar
velvet123613753velvet
venal85523213v_enal
venial94218283venial
verbal112513663verbal
vernal93514213vernal
versal93013753versal
vestal94615573vestal
vial76731093v__ial
vill75235073vil__l
villa85321233villa_
villae95615383villae
villas96117263villas
vinal85725813v_inal
vineal94814743vineal
viral86419593v_iral
visual938803visual
vital84819673v_ital
viva106119093v_iva_
vivas114815023v_ivas
vocal104715643v_ocal
volar86917413vol_ar
volta85215623volta_
volvate13317993volvate
volvox1933363volvox
volvuli1352083volvuli
vulgarly1543163vulgarly
vulgars11306533vulgars
vulgate11388433vulgate
vulgo936953vul_go
vulgus1035783vulgus
yulan8411493yul_an

Search took 6 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.376475242.0
2DLD Change Limit1127161925.11022057.9
3Display Results1921920.0603200.0
 (SQL Overall)1786911925.54632219.8
 
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.