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

360 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
lavash1259737(None) 
lavas85422221lavas_
lavish124112981lavish
abash106016512_abash
avast85519362_avast
awash116613162_awash
calash11312432calash
favas115618592favas_
javas155915422javas_
kavas125919952kavas_
kavass13517302kavass
lamas75532792lamas_
larvas9310232larvas_
lash76539652l__ash
latish92416172latish
lava76725422lava__
lavabo1135272lavabo
lavage1038262lavage
lavashes1445572lavashes
laves86039152laves_
lavs76734152lav_s_
leash85519212l_eash
ravish123414032ravish
slavish1338232slavish
aah616252963_a_a_h
aahs716428563_a_ahs
aas310975393_a_as_
abas68642083_abas_
abase76023483_abase
agas55938843_agas_
alas46358123_alas_
albas75925393albas_
alfas87219043alfas_
algas65624933algas_
alias55834603alias_
almah106917253alma_h
almahs118611613almahs
almas76629773almas_
amah98927483_ama_h
amahs107819063_amahs
amas67746293_amas_
amass77119683_amass
anas46649863_anas_
apish105116633_apish
ash67944603___ash
ava610139323_ava__
avail8313883_avail
avant86224663_avant
aves76142603_aves_
avgas96912133_avgas_
aviso85713963_aviso
avos77227013_avos_
ayah108022993_aya_h
ayahs116813523_ayahs
baas66844673ba_as_
babas96325733babas_
badass949293badass
bagass938933bagass
balas76937213balas_
banish111416043banish
bash915240163__bash
brash106221563_brash
bravas114913323bravas_
cacas95627983cacas_
calabash1544253calabash
camas96333523camas_
camass104114183camass
canvas113813333canvas_
canvass12376873canvass
carwash1535993carwash
casas75327843casas_
cash96636283__cash
caves105639703caves_
clash106219033_clash
clavate1238713clavate
claves115020063claves_
clavus11347353clavus_
clayish1547943clayish
crash109120013_crash
dadas75819863dadas_
dalasi7610623dalasi
damask1335843damask
danish101513793danish
dash87031633__dash
deash95617243_deash
devas96218883devas_
divas95418583divas_
dovish1338103dovish
eaves85231993eaves_
elvish1277563elvish
emdash12244113emdash
encash11276943encash
endash10297123endash
famish14311843famish
fash107232293__fash
fava106820263fava__
faves115331423faves_
favism1437913favism
favus114311733favus_
flash115716213_flash
flatwash1742423flatwash
galah95917623gala_h
galahs105512673galahs
galas65731643galas_
galosh1038553galosh
gamas85431353gamas_
garish104516923garish
gash86833023__gash
gavage1137193gavage
gnash9449833_gnash
guavas1037153guavas_
hahas117118443hahas_
halavah16447013halava_h
halavahs17415793halavahs
halvah15499833halva_h
halvahs16417533halvahs
halvas124714173halvas_
harass9313943harass
harsh116418053ha_rsh
hash106936503__hash
haves116034873haves_
jadish17319903jadish
java147316643java__
kaas86531843ka_as_
kakas85117343kakas_
kanas95326913kanas_
kapas116021733kapas_
katas95922093katas_
kava115819703kava__
kivas124614733kivas_
knavish1743993knavish
kuvasz2242233kuvasz
kvas117015943_kvas_
kvass12507273_kvass
laari54415713la_ari
labara83712893labara
labs67145123la_bs_
laces76141763laces_
lacks116129203lacks_
lacs66942483la_cs_
lactase937953lactase
laddish12299723laddish
lades65141273lades_
lads56549133la_ds_
ladyish14287823ladyish
lagan66520343laga_n
lagans75717783lagans
lags56546223la_gs_
lahar83114263laha_r
lahars94013163lahars
laich105920713la_ich
laichs115110893laichs
laics76419253laics_
laigh95515923la_igh
laighs10508803laighs
lairs55425873lairs_
laith85722103la_ith
lakes95737653lakes_
lakh114919953l__akh
lakhs125210343lakhs_
lalls55324133lalls_
lama66635293lama__
lambast11129893lambast
lambs95921413lambs_
lamedh12476363lamedh
lames75445543lames_
lamest84722763lamest
lamias85020613lamias_
lampas106615953lampas_
lamps95624833lamps_
lams66552263la_ms_
lanai5319573lana_i
lanais6316793lanais
lanate6421263lanate
lands65426903lands_
lanes54946793lanes_
lanose6313593lanose
lapis76223153lapis_
laps66848873la_ps_
lapse74917683la_pse
larch105919793la_rch
lards65331863lards_
lares54852633lares_
largish1138603largish
laris54737463laris_
larkish1439083larkish
larks95227813larks_
lars46956573la_rs_
larva8312483larva__
larvae938843larva_e
larval948503larva_l
las37281473l__as_
lase46148513l__ase
lases54944763lases_
lass47444543l__ass
lassi56316853la_ssi
lasso55015683la_sso
last46260323l__ast
lasts57731263lasts_
latch104620463la_tch
latest63822703latest
lath76640383l__ath
laths86022403laths_
lats45962703la_ts_
lauan55216793laua_n
lauans65113533lauans
lauds65618483lauds_
laugh94414373la_ugh
laughs10489023laughs
launch11368063launch
lauras63414333lauras_
lav66847343lav___
lavabos1235453lavabos
lavages1138603lavages
lave75642143lav__e
laved95028593lav_ed
laveer94110423laveer
laver85031793lav_er
lavers94526363lavers
laving104623573laving
lavished1555133lavished
lavisher1445083lavisher
lavishes1457403lavishes
lavishly1744413lavishly
lawns85215423lawns_
laws76441683la_ws_
laxes125430093laxes_
laxest134913363laxest
lays76043253la_ys_
lazar144113643laza_r
lazars153812393lazars
lazes145129573lazes_
lazyish22265853lazyish
leach105422523l_each
leas45954183l_eas_
lease55230263l_ease
least56134883l_east
leaves94222383leaves_
leva77020713leva__
levant9314493levant
levis85818553levis_
lianas63713383lianas_
ligase7259913ligase
limas75627633limas_
lipase8239103lipase
liras56021983liras_
litas54923773litas_
lives86133193lives_
livest95315733livest
llamas888973llamas_
loach105116363l_oach
loath84918603l_oath
loaves94813853loaves_
lotah85315853lota_h
lotahs9479873lotahs
lotas55926303lotas_
lovage1037353lovage
lovat8321043lova_t
lovats939073lovats
loves85332013loves_
lowish12310533lowish
lumas75622913lumas_
lunas55025013lunas_
lush75327693l__ush
luvs75818503luv_s_
lyase85512413l_yase
mamas95930773mamas_
manas76240423manas_
maras75443283maras_
marish114319053marish
marsh105320853ma_rsh
masas75630413masas_
mash96039393__mash
matsah1138233matsah
mavis105622723mavis_
mayas105924383mayas_
nadas66320813nadas_
nalas55528363nalas_
nanas55928633nanas_
napas75924353napas_
navaid1037643navaid
naval85315833nava_l
navar83912733nava_r
navars92810573navars
naves87030383naves_
novas85215363novas_
oafish121311723oafish
oaves84925613oaves_
pacas96029403pacas_
palish114718273palish
papas94927493papas_
paraph13311263paraph
paras76143043paras_
parish115022353parish
pash95638133__pash
pavan106518473pava_n
pavane114113443pavane
pavans115715593pavans
paves104833923paves_
pavis106422733pavis_
pavise114714803pavise
planish12412053planish
plash104616563_plash
playas114612283playas_
plazas17409913plazas_
potash1138273potash
quamash2144283quamash
quash174512163_quash
radish103516913radish
ragas65326063ragas_
raias54631123raias_
rajah155711423raja_h
rajahs16497663rajahs
rajas127317723rajas_
rakish134313963rakish
rash76039933__rash
ravage1039303ravage
raves85441973raves_
rawish123012913rawish
rayah116013503raya_h
rayahs12579193rayahs
rayas85922053rayas_
rehash1237433rehash
rewash1237673rewash
sagas66025883sagas_
sash77235303__sash
savage10410173savage
savant9416043savant
savate9313783savate
saves85838633saves_
slapdash1442393slapdash
slash84719683_slash
slaves95023023slaves_
smash104814433_smash
snash84815673_snash
splash1168823splash
squash1846833squash
stash84916973_stash
swash116316753_swash
takas95520683takas_
talas55935893talas_
tamasha12125423tamasha
tapas74627713tapas_
tavs75630973tav_s_
thrash12258353thrash
trash86119763_trash
ulamas8910453ulamas_
ulvas84511503ulvas_
unlash938793unlash
vanish121513203vanish
varas86028193varas_
vas67755773__vas_
vasa76522973__vasa
vase75629653__vase
vast75045123__vast
vavasor13143603vavasor
vavs105720433vav_s_
vivas114815023vivas_
wash106033813__wash
waves115633923waves_

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.1401276364.3
2DLD Change Limit1127163605.08022188.2
3Display Results3603600.1063396.2
 (SQL Overall)1786913605.32633550.7
 
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.