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

103 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
lavabos123545(None) 
lavabo1135271lavabo_
lavaboes1344431lavaboes
gazabos1944452gazabos
lavages1138602lavages
lavas85422222lava__s
abos67734413___abos
adobos9438453_adobos
alamos8415003_alamos
ambos95321253_a_mbos
anabas8314083_anabas
avails939693_avails
avisos95410483_avisos
avos77227013_av__os
bayamos1434663bayamos
bravados1443223bravados
cacaos104616183caca_os
calvados1444813calvados
carabaos1238083carabaos
carbos105122263ca_rbos
casabas1139983casabas
catalos9414163catalos
favas115618593fava__s
flavanol1442403flavanol
flavanols1542203flavanols
galagos938153galagos
gavages1237683gavages
gazabo1834833gazabo_
gazaboes2043873gazaboes
gazebos1933493gazebos
javas155915423java__s
jazzbos2442033jazzbos
kababs14409773kabab_s
kakapos1243673kakapos
kavas125919953kava__s
kavass13517303kava_ss
labor75117313l__abor
labors84016413l__abors
labs67145123l__ab_s
ladinos8389963ladinos
lagans75717783laga_ns
lahars94013163laha_rs
lamas75532793lama__s
lambs95921413la_mb_s
lanais6316793lana_is
lanugos834453lanugos
largos74815063la_rgos
larvas9310233larva__s
lassos64913813la_ssos
latigos8277243latigos
latinos73613803latinos
lauans65113533laua_ns
lava76725423lava___
lavage1038263lava_ge
lavash12597373lava_sh
lavashes1445573lavashes
lavation1139973lavation
lavations1238973lavations
lavatory1445703lavatory
laveers10329363laveers
lavers94526363lav_ers
laves86039153lav__es
lavs76734153lav___s
layabout1345163layabout
layabouts1442573layabouts
lazars153812393laza_rs
legatos82711183legatos
lesbos837403l_esbos
levants1037723levants
levator10298963levator
levators11249283levators
limbos104712143l_imbos
livable122010323livable
llanos6108333l_lanos
lobos75921843l__obos
lovable12179553lovable
lovably15187063lovably
lovages1138033lovages
lovats939073lova_ts
macacos1338083macacos
mambos125414493ma_mbos
marabou1147493marabou
marabous1249063marabous
navaids1134803navaids
navars92810573nava_rs
nawabs1185063nawab_s
ovibos1145463_ovibos
parados103816053parados
paramos113213513paramos
pavanes123612653pavanes
pavans115715593pava_ns
placebos1443713placebos
rabatos93010903rabatos
ravages1139403ravages
sambos104315193sa_mbos
savable121711863savable
savages1139973savages
savants1038653savants
savates10312953savates
tapalos938813tapalos
vavasor13143603vavasor
vavasors14153653vavasors
wasabis1255363wasabis

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 Filter1786911340270.576310227.4
2DLD Change Limit1340271037.00019146.7
3Display Results1031030.0303433.3
 (SQL Overall)1786911037.60623493.4
 
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.