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

435 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
larvae93884(None) 
larva8312481larva_
larval948501larval
larvas9310231larvas
areae55229742_areae
arval86017012_arval
carve106227752carv_e
lamiae84817452lamiae
laree56036292lar_ee
large65325462lar_ge
lariat6629042lariat
larine63927042larine
laurae64011662laurae
lava76725422la_va_
lavage1038262la_vage
lavas85422222la_vas
lave75642142la_v_e
parae76335702par_ae
parve109824852parv_e
varve115716852varv_e
agave95314033_agave
alae45643753_a_lae
algae65319623_algae
alive85722513aliv_e
alulae6312743alulae
ansae55720973_ansae
antae56828293_antae
aortae65115473aortae
aquae142212713_aquae
arak86929573_ar_ak
arame75026623_arame
arcade91013643_arcade
arcane81216743_arcane
are37874573_ar__e
area45843393_area_
areal55928733_areal
areas55935773_areas
arene55329413_arene
arete56031353_arete
argal65023393_argal
argle65421563_argle
argue64818443_argue
arhat8327093_arhat
aria46245423_aria_
arias55438023_arias
arise56436433_arise
arose55832083_arose
arras55626133_arras
array86317143_array
arse46539273_ar_se
artal55525473_artal
arvo76023433_arv_o
arvos86015663_arvos
aurae54128113_aurae
ava610139323_a_va_
ave67748703_a_v_e
baccae12119703baccae
barbal104016663barbal
barbate11314543barbate
barbe95328283bar_be
barbie105018353barbie
barca91319433barca_
barcas101016603barcas
barde85330773bar_de
bare65460523bar__e
barege94713543barege
barge85631023bar_ge
bargee94624443bargee
barite84224813barite
barman103519703barman
barmie103816393barmie
barque17239553barque
barrage10710843barrage
barre75929543bar_re
barware12610703barware
barye105021493bar_ye
baryte115312883baryte
blare75826233blar__e
brae65639113_br_ae
brava106414793brava_
bravas114913323bravas
brave104925503brav_e
bursae84515603bursae
calve105919923calv_e
canvas113813333canvas
carafe115416163carafe
carat75048793car_at
carate84734003carate
caravan1239233caravan
caravel1238213caravel
carcase11312743carcase
cardiae10713713cardiae
care66968373car__e
carfare12310073carfare
caribe103416753caribe
carinae94318593carinae
carle74535703car_le
carman103920743carman
carnage10311743carnage
carnal83919213carnal
carnie84421093carnie
carpal103716253carpal
carpale113414353carpale
carse74934333car_se
cartage10312593cartage
carte75940423car_te
carved124320853carved
carvel114817573carvel
carven114716663carven
carver114420153carver
carves115128453carves
cave95941263ca_v_e
cavie104621593ca_vie
clavate1238713cla_vate
clave105420153cla_v_e
corvee114320093corvee
cravat11314443cravat
crave105626313crav_e
curiae84518373curiae
curve104920023curv_e
darbar959953darbar
dare55848863dar__e
darkie113714013darkie
darkle113813943darkle
dartle73714833dartle
drave95219273drav_e
earlap837183earlap
earwax1664733earwax
eave75733583ea_v_e
faciae112913413faciae
farad95720673far_ad
farce104925323far_ce
farcie114816473farcie
fare76354463far__e
farfal123410183farfal
farle86929243far_le
faunae95210373faunae
fauve114712073fauv_e
fava106820263fa_va_
favas115618593fa_vas
fave105532963fa_v_e
feriae95618603feriae
filariae1148473filariae
flare84823633flar__e
florae94713883flor_ae
frae75330473_fr_ae
galeae74717453galeae
garage8314513garage
garbage1138053garbage
garble94118453garble
garda7316763garda_
gardai839663gardai
gargle84215463gargle
garote7717953garote
garvey13127873garvey
gavage1137193ga_vage
gave84634053ga_v_e
glaive10357933glaiv_e
glare65222963glar__e
grave94624873grav_e
halva115414433halva_
halvah15499833halvah
halvas124714173halvas
halve114818923halv_e
hare76255733har__e
hartal9415473hartal
have106137073ha_v_e
hermae115314473hermae
jarrah1636683jarrah
jarvey19135403jarvey
java147316643ja_va_
javas155915423ja_vas
jayvee1957613jayvee
karat96837593kar_at
karate105320923karate
karma113415003karma_
karmas123013733karmas
kava115819703ka_va_
kavas125919953ka_vas
labia75219013labia_
labial84714343labial
labiate91313573labiate
labile8315223labile
labra75415463labra_
lace66848473la__ce
lactam10310943lactam
lactase937963lactase
lactate9312703lactate
lacunae9116803lacunae
lacune8169673lacune
laddie83713173laddie
lade56345983la__de
ladle66320443la_dle
ladrone83611873ladrone
laevo849363laev_o
lagan66520343la_gan
lagune7158633lagune
lahar83114263la_har
laical8312323laical
lake85741603la__ke
lallan63414173lallan
lama66635293la_ma_
lamas75532793la_mas
lambie103213673lambie
lame66849293la__me
lamia75324323lamia_
lamias85020613lamias
laminae93512973laminae
lampad114510033lampad
lampas106615953lampas
lanai5319573la_nai
lanate6421263lanate
lance75126723la_nce
landau7310613landau
lane45153333la__ne
langue71012173langue
lanose6313593lanose
laogai735983laogai
lapse74917683la_pse
lar37967533lar___
larch105919793lar_ch
larchen12479633larchen
larches124416453larches
lard56742003lar__d
larded84319093larded
larder73720973larder
lardier83518343lardier
lardon74415063lardon
lards65331863lar_ds
lardy96119273lar_dy
larees65323113larees
lares54852633lar_es
larger74417513larger
larges74824233larges
largo65319783lar_go
largos74815063largos
lari45839153lar__i
lariated91212063lariated
lariats7615053lariats
laris54737463lar_is
lark85733863lar__k
larked114519473larked
larker104519243larker
larkier113711523larkier
larks95227813lar_ks
larky125218873lar_ky
larrup835713larrup
lars46956573lar__s
larum74317973lar_um
larums83610533larums
larynx1632853larynx
lascar868573lascar
lase46148513la__se
lassie64917743lassie
late47560483la__te
lathe85626723la_the
latke94817093la_tke
latria62313603latria_
latrias71913213latrias
latrine7715133latrine
latte55426303la_tte
lauan55216793la_uan
launce8469183launce
laura54116203laura_
lauras63414333lauras
laureate888023laureate
lav66847343la_v__
lavabo1135273la_vabo
lavages1138603la_vages
lavash12597373la_vash
laved95028593la_ved
laveer94110423la_veer
laver85031793la_ver
laves86039153la_ves
lavs76734153la_v_s
lawine93316463lawine
lawman11289053lawman
layman113511303layman
lazar144113643la_zar
laze136235053la__ze
leave84723723leav_e
lekvar1333043lekvar
leva77020713l_eva_
levee84023813l_evee
librae84310173librae
lieve86315473liev_e
lira46928683lir_a_
liras56021983lir_as
lire47845293lir__e
live76540993l_iv_e
livre85613253l_ivre
loral55927823lor_al
loran55925093lor_an
lore45850353lor__e
loreal63814313loreal
loricae938253loricae
louvre9425683louvre
lovage1037353l_ovage
lovat8321043l_ovat
love75234763l_ov_e
lurdan738363lurdan
lurdane835983lurdane
lure45142463lur__e
lyrate94112103lyrate
lyre75623793lyr__e
lyttae994713lyttae
mammae94613213mammae
mara67444573mar_a_
maras75443293mar_as
marble104219103marble
mare64759333mar__e
margay12310593margay
marge85328333mar_ge
maria75032883maria_
marine84230403marine
marka114620793marka_
markas124717003markas
marque172410503marque
marram10313883marram
marse76231153mar_se
marvel113712003marvel
marvy135014033marv_y
mauve104013273mauv_e
mavie104722563ma_vie
morae75831193mor_ae
naive85116213naiv_e
narial6317953narial
narine63422553narine
narrate7313493narrate
narwal938943narwal
naval85315833na_val
navar83912733na_var
nave75732313na_v_e
nervate1039533nervate
nerve86617373nerv_e
novae85913123_novae
ocreae83310273ocreae
paleae84820293paleae
para65242173par_a_
parade94720643parade
paras76143043par_as
paravane1348103paravane
parbake1538353parbake
pardah123412823pardah
pardee93922023pardee
pardie96021443pardie
pare66760843par__e
pareve114613013pareve
parge85831853par_ge
pariah114320583pariah
parian83223963parian
parka115120883parka_
parkade1437583parkade
parkas125018023parkas
parlay113713993parlay
parle75836163par_le
parole84425253parole
parral85517533parral
parse75236993par_se
partake1339643partake
partan83820563partan
parure8312523parure
parvis116114803parvis
parvise124211693parvise
parvo107719183parv_o
parvos116614753parvos
pavan106518473pa_van
pavane114113443pa_vane
pave96133893pa_v_e
pervade1337023pervade
raphae114311733raphae
rare45348433rar__e
ravage1039303ra_vage
rave75542093ra_v_e
salpae84614273salpae
salvage1138193salvage
salve85022133salv_e
saran53730303sar_an
sarape84817573sarape
sardar73013173sardar
saree55044663sar_ee
sarge65531133sar_ge
sarode75317513sarode
sarsar63011843sarsar
savage10410173sa_vage
savate9313783sa_vate
save75741363sa_v_e
serval93913413serval
serve85425963serv_e
silvae92811093silvae
slave84224033sla_v_e
starve94613743starv_e
striae65422273striae
sylvae12236863sylvae
tare45957623tar__e
targe65227093tar_ge
tarmac10310333tarmac
tarnal63716503tarnal
tarpan82814293tarpan
tarre55825633tar_re
tarsal63315273tarsal
tartan64217513tartan
tartar63214753tartar
tartare73012683tartare
tarzan152910753tarzan
terrae62915213terrae
thrave126010273thrave
trave85223033trav_e
ursae55214453_ursae
valval12398863valval
valvar12388653valvar
valvate133710813valvate
valve114515933valv_e
vara75530883var_a_
varas86028193var_as
varia85824203varia_
varias95019903varias
variate101316433variate
varna84516173varna_
varnas94212823varnas
varved134110603varved
varves124414783varves
verve115417723verv_e
vulvae12438033vulvae
waive114214603waiv_e
warble113516603warble
ware76254723war__e
warfare1336733warfare
warpage1336403warpage
warsaw1236193warsaw
warsle93112923warsle
wave105234733wa_v_e
wharve15456203wharv_e
yardage1235733yardage
yare75636943yar__e

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.390458182.1
2DLD Change Limit1127164355.29621283.2
3Display Results4354350.1263452.4
 (SQL Overall)1786914355.81230745.2
 
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.