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 “laze” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

373 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
laze13623505(None) 
blaze165520831blaze
daze147327231daze
faze165630041faze
gaze145032411gaze
glaze155418161glaze
haze164833391haze
lace66848471lace
lade56345981lade
lake85741601lake
lame66849291lame
lane45153321lane
lase46148511lase
late47560481late
lave75642141lave
lazed154925841lazed
lazes145129571lazes
lazy166423071lazy
maze155434971maze
raze135235431raze
ablaze17239832ablaze
ace59656832_ace
adze1412820572adze
ae212590292_a_e
agaze156113662agaze
age47154332_age
alae45643752alae
alane56135612alane
alate55340322alate
ale36572342_ale
alee46652322alee
alme65832162alme
aloe45540192aloe
amaze166016602amaze
ane37866942_ane
ape57251182_ape
are37874572_are
ate37059242_ate
ave67748702_ave
awe67746622_awe
axe108239492_axe
aye67151762_aye
azo128233392_azo
babe86835812babe
bade75140882bade
baize164717392baize
bake105637512bake
bale66353842bale
bane65250422bane
bare65460522bare
base64847022base
bate66552422bate
bize155926282bize
blade85923332blade
blae66134642bla_e
blame95625492blame
blare75826232blare
blase75524232blase
blate75933782blate
blazed184314712blazed
blazer174414022blazer
blazes174817352blazes
braze165423452braze
cade76443912cade
cafe95230322cafe
cage75339062cage
cake105439962cake
came87648752came
cane66653112cane
cape87242782cape
care66968372care
case65848082case
cate66254592cate
cave95941262cave
clade85821012clade
clave105420152clave
cloze165517542cloze
craze165221462craze
dace76934922dace
dale55643982dale
dame77140312dame
dare55848862dare
date56443322date
dazed165919362dazed
dazes155024142dazes
doze145829082doze
ease45042332ease
eave75733582eave
elate55335882elate
face96140122face
fade85736342fade
fake115534942fake
fame95639392fame
fane75343562fane
fare76354462fare
fate75444282fate
fave105532962fave
fazed186222962fazed
fazes175527212fazes
feaze175216312feaze
flake125119972flake
flame105124442flame
flare84823632flare
fuze166422372fuze
gae46457702ga_e
gage65936102gage
gale56347322gale
game76644322game
gane55145292gane
gape75134512gape
gate55746572gate
gauze155712972gauze
gave84634052gave
gazed165520332gazed
gazer155720072gazer
gazes155425912gazes
glace87420152glace
glade75121962glade
glare65222952glare
glazed174711772glazed
glazer164212262glazer
glazes165315642glazes
glazy187410982glazy
gloze154815982gloze
graze155820052graze
hade85440192hade
hae67364002ha_e
hake115637842hake
hale76052832hale
hame97043132hame
hare76255732hare
hate78450172hate
have106137072have
hazed185222202hazed
hazel176414812hazel
hazer174820232hazer
hazes174928322hazes
hazy1918119192hazy
jade125325442jade
jake155925772jake
jane115031472jane
jape134923422jape
jazz193714462jazz
kae76744542ka_e
kale86533752kale
kame105728232kame
kane85133962kane
la219261632la__
lab58864782la_b
label75019382label
labs67145122labs
lac510155822la_c
laced87132642laced
lacer75833752lacer
laces76141762laces
lacey105820912lacey
lack105837682lack
lacs66942482lacs
lacy95829632lacy
lad48165702la_d
laded74232612laded
laden65022192laden
lader65633722lader
lades65141272lades
ladle66320442ladle
lads56549132lads
lady86527152lady
lag47862122la_g
lager65132862lager
lags56546222lags
laic65931562laic
laid56439142laid
lain46146282lain
lair45934152lair
laked105731122laked
laker95432872laker
lakes95737652lakes
lakh114919952lakh
laky116725822laky
lall45531312lall
lam57666712la_m
lama66635292lama
lamb86832142lamb
lamed85235292lamed
lamer75233702lamer
lames75445542lames
lamp86233822lamp
lams66552262lams
lance75126722lance
land56337302land
lanes54946792lanes
lang56637372lang
lank84734442lank
lap58565272la_p
lapel73716682lapel
laps66848872laps
lapse74917682lapse
lar37967532la_r
lard56742002lard
laree56036292laree
lares54852632lares
large65325462large
lari45839152lari
lark85733862lark
lars46956572lars
las37281472la_s
lased65132342lased
laser54633322laser
lases54944762lases
lash76539652lash
lass47444542lass
last46260322last
lat37593402la_t
lated65240672lated
laten54328342laten
later54843922later
latex124717112latex
lath76640382lath
lathe85626712lathe
lati46438272lati
latke94817092latke
lats45962702lats
latte55426302latte
latu47934182latu
laud56527722laud
lav66847342la_v
lava76725422lava
laved95028592laved
laver85031792laver
laves86039152laves
lavs76734152lavs
law68656642la_w
lawed96028322lawed
lawn75925632lawn
laws76441682laws
lax107651522la_x
laxer125420332laxer
laxes125430092laxes
lay68865352la_y
layed95127382layed
layer84626472layer
lays76043252lays
lazar144113642lazar
lazied164610652lazied
lazier154214612lazier
lazies154418782lazies
lease55230262lease
leave84723722leave
lee36068142l_ee
leke85527402leke
lez125541312lez_
liane54720662liane
lice66045062lice
lie38264522l_ie
life75433732life
like86040842like
lime66244932lime
line46965572line
lipe66839732lipe
lire47845292lire
lite47054542lite
live76540992live
lobe65535362lobe
lode56240112lode
loge56837192loge
lone45849132lone
lope65941922lope
lore45850352lore
lose45144582lose
love75234762love
lowe75435312lowe
lube64731562lube
luce65132572luce
lude55331642lude
luge55531642luge
lune47140492lune
lure45142462lure
lute46341012lute
luxe115222692luxe
lyase85512412lyase
lye66533412l_ye
lyre75623792lyre
lyse76320592lyse
mabe85733342mabe
mace87345782mace
made75440232made
mae57659102ma_e
mage75739122mage
maize164618552maize
make105537882make
male66052292male
mane65052012mane
mare64759322mare
mate65154212mate
mazed175523872mazed
mazer165722422mazer
mazes165632172mazes
mazy186419692mazy
meze154420902meze
nabe66029492nabe
nae35952742na_e
name65637412name
nape65230802nape
nave75732312nave
nazi136219872nazi
ooze136420602ooze
pace86345772pace
page76036102page
pale66055012pale
pane64950282pane
pare66760842pare
pase65346862pase
pate65350462pate
pave96133892pave
place94824612place
plage84520402plage
plane74929142plane
plate74635112plate
plaza164311062plaza
race66746262race
rage55742352rage
rake84841572rake
rale45050562rale
rape65041632rape
rare45348432rare
rase46149982rase
rate45458762rate
rave75542092rave
razed155027982razed
razee145827802razee
razer144824272razer
razes145032702razes
razz125219422razz
sabe66140572sabe
sade55544472sade
sae38365182sa_e
safe75930952safe
sage55044592sage
sake85244962sake
sale44959702sale
same65245642same
sane45954332sane
sate45556102sate
save75741362save
size135630962size
slake93724052slake
slate55438282slate
slave84224032slave
sleaze152611862sleaze
smaze165012932smaze
tace65342512tace
tae38267052ta_e
take84739262take
tale46154162tale
tame66343662tame
tape64538142tape
tare45957622tare
tate44748602tate
tazze1339572tazze
vale74937342vale
vane75534682vane
vase75629652vase
wade85237062wade
wae67556952wa_e
wage84834082wage
wake114935702wake
wale74546432wale
wame95035482wame
wane76344712wane
ware76254722ware
wave105234732wave
yare75636942yare
zazen1337282zazen

Search took 2 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 Filter178691298720.0802233637.5
2DLD Change Limit298723731.01329488.6
3Display Results3733730.0804662.5
 (SQL Overall)1786913731.173152336.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.