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

127 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
lavabo113527(None) 
lavabos1235451lavabos
gazabo1834832gazabo
lava76725422lava__
lavaboes1344432lavaboes
lavage1038262lavage
lavas85422222lava_s
lavash12597372lavash
abo59045963___abo
adobo84711593_adobo
alamo7418143_alamo
ambo88225133_a_mbo
ava610139323_ava__
avail8313883_avail
avant86224663_avant
avast85519363_avast
aviso85713963_aviso
avo68936233_av__o
bayamo1335603bayamo
bravado1343603bravado
cacao95420003caca_o
carabao1139673carabao
carbo94923843ca_rbo
casaba1079263casaba
catalo8314853catalo
clavate1238713clavate
fava106820263fava__
favas115618593fava_s
flavanol1442403flavanol
galago838903galago
gavage1137193gavage
gazabos1944453gazabos
gazebo1833673gazebo
java147316643java__
javas155915423java_s
jazzbo2342713jazzbo
kabab134814433kabab_
kababs14409763kababs
kakapo1143853kakapo
kava115819703kava__
kavas125919953kava_s
kavass13517303kavass
laari54415713la_ari
lab58864783l__ab_
labara83712893labara
labor75117313l__abor
labs67145123l__abs
ladino73615123ladino
laevo849363la_evo
lagan66520343laga_n
lagans75717783lagans
lahar83114263laha_r
lahars94013163lahars
lama66635293lama__
lamas75532793lama_s
lamb86832143la_mb_
lambs95921413la_mbs
lamby125114843la_mby
lanai5319573lana_i
lanais6316793lanais
lanate6421263lanate
lanugo735573lanugo
largo65319783la_rgo
larva8312483larva__
larvae938843larva_e
larval948503larva_l
larvas9310233larva_s
lasso55015683la_sso
latigo73410013latigo
latino64120473latino
lauan55216793laua_n
lauans65113533lauans
lav66847343lav___
lavages1138603lavages
lavation1139973lavation
lavatory1445693lavatory
lave75642143lav__e
laved95028593lav_ed
laveer94110423laveer
laver85031793lav_er
lavers94526363lavers
laves86039153lav_es
laving104623573laving
lavish124112983lavish
lavs76734153lav__s
layabout1345163layabout
lazar144113643laza_r
lazars153812393lazars
legato72810953legato
lesbo739253l_esbo
leva77020713leva__
levant9314493levant
levator10298963levator
levo76820063lev__o
limbo95614803l_imbo
livable122010323livable
llano5910603l_lano
lobo67229863l__obo
lovable12179553lovable
lovably15187063lovably
lovage1037353lovage
lovat8321043lova_t
lovats939073lovats
macaco1247853macaco
mambo115215733ma_mbo
marabou1147493marabou
navaid1037643navaid
naval85315833nava_l
navar83912733nava_r
navars92810573navars
nawab10810923nawab_
nawabs1185063nawabs
paramo102614643paramo
pavan106518473pava_n
pavane114113443pavane
pavans115715593pavans
placebo1343293placebo
rabato83413263rabato
ravage1039303ravage
sambo95118013sa_mbo
savable121711863savable
savage10410173savage
savant9416043savant
savate9313783savate
tapalo839793tapalo
vavasor13143603vavasor
wasabi1154643wasabi

Search took 8 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.1261418182.5
2DLD Change Limit1127161277.28315476.6
3Display Results1271270.0761671.1
 (SQL Overall)1786911277.48523873.2
 
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.