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

112 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
lazulis163490(None) 
lazuli1535361lazuli_
azukis1963732_azukis
caulis85320082ca_ulis
lazulite1745032lazulite
lazulites1844252lazulites
tabulis938832tabulis
abulia83512503_abulia
abulias93210693_abulias
abulic106411423_abulic
adults7299953_adults
adzukis2141553adzukis
aiolis6316843_aiolis
alkalis11148793alkalis
aulic74420243_a_ulic
auris55331533_a_uris
azoles154614613_azoles
azuki1864803_azuki_
azures15510183_azures
babuls105413643babul_s
baulks12429373ba_ulks
buzukis2242663buzukis
canulas9312853canulas
caulds95512383ca_ulds
caules85927253ca_ules
caulks125611863ca_ulks
cauls75727773ca_ul_s
coulis84018763_coulis
dazzles1636413dazzles
fabulist1347673fabulist
famuli1136763famuli_
famulus1235043famulus
faulds10438963fa_ulds
faults94513553fa_ults
gaults74112783ga_ults
gazumps2131873gazumps
hamuli1137063hamuli_
hamulus1235323hamulus
haulms11558503ha_ulms
hauls86123733ha_ul_s
hazels185710083hazel_s
kabukis1243193kabukis
kauris103611533ka_uris
labels84515683label_s
lacunas9138173lacunas
lacunes9159623lacunes
ladles74619543la_dles
lagunas8156823lagunas
lagunes8148523lagunes
lalls55324133la__lls
lanais6316793la_nais
lanolin7310643lanolin
lanolins8310533lanolins
lanugos834453lanugos
laogais845813laogais
lapels83712043lapel_s
lapfuls1234503lapful_s
lapis76223153la__pis
laris54737463la__ris
larums83610533laru_ms
lassis65216703la_ssis
lathis95516173la_this
lauans65113533la_uans
lauds65618483la_u_ds
laughs10489023la_ughs
lauras63414333la_uras
layups1133993layu_ps
lazars153812393laz_ars
lazes145129573laz__es
lazies154418783laz_ies
lazily1859713lazil_y
lazurite1745243lazurite
lazurites1844583lazurites
lazyish22265853laz_yish
levulin1044663levulin
levulins1144803levulins
ligulas8329173ligulas
ligules82210923ligules
limuli836343limuli_
limulus935083limulus
lobules92510813lobules
locules92812603locules
loculi8288253loculi_
loculus9296973loculus
louis57322323l_ou_is
lulls54119653l__ulls
lulus54315163l__ulus
lunules738953lunules
lupulin945003lupulin
lupulins1044653lupulins
maculas113114023maculas
macules114015133macules
maquis17249483maqu_is
mauls76524953ma_ul_s
mazumas2034623mazumas
nazis145216083naz__is
papules112411573papules
paulin8312983pa_ulin
paulins9312613pa_ulins
pulis74225603__pulis
radulas839583radulas
ranulas7311773ranulas
salukis1136033salukis
sauls55128123sa_ul_s
saults65816173sa_ults
taboulis1045043taboulis
tabuli839363tabuli_
tallis63319963ta_llis
tanukis1134713tanukis
tzuris15286913_tzuris
vaults94511673va_ults
wauls86120553wa_ul_s

Search took 7 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.1401276364.3
2DLD Change Limit1340271126.23321502.8
3Display Results1121120.0333393.9
 (SQL Overall)1786911126.40627894.3
 
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.