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

175 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
piazze163468(None) 
piazza1643821piazza
piaffe1494912piaffe
piazzas1743642piazzas
pizazz1554222pizazz
pizazzes1742372pizazzes
pizazzy1952242pizazzy
pizza1538182pi_zza
pizzle16279492pizzle
tazze1339572_tazze
adze1412820573__adze
agaze156113663aga_ze
amaze166016603ama_ze
baize164717393_baize
bize155926293bi__ze
bizzes163910843bi_zzes
blaze165520833bla_ze
braize174113113braize
braze165423453bra_ze
chazzen20214783chazzen
craze165221463cra_ze
daze147327233_da_ze
dazzle1536853_dazzle
dialyze2044433dialyze
diazin1639163diazin
diazine1738933diazine
diazo15310033dia_zo
diazole1736793diazole
dizzy177410853di_zzy
faze165630043_fa_ze
feaze175216313fea_ze
fiacre1137623fiacre
fiance11310743fiance
fizz157519823fi_zz_
fizzed18369443fi_zzed
fizzer17369383fi_zzer
fizzes174512553fi_zzes
fizzle17369713fizzle
fizzy199015083fi_zzy
frazzle18305223frazzle
gauze155712973_gauze
gaze145032413_ga_ze
glaze155418163gla_ze
graze155820053gra_ze
haze164833393_ha_ze
jazz193714463_jazz_
jazzed22416293_jazzed
jazzer21376503_jazzer
jazzes21347883_jazzes
jazzy23396363_jazzy
laze136235053_la_ze
liable81415813liable
liaise6310693liaise
liane54720663lia_ne
maize164618563_maize
maze155434983_ma_ze
mizzen16447953mi_zzen
mizzle16279993mizzle
opiate8513463opia_te
pace86345773p_a_ce
padle84522343p_adle
padre86018163p_adre
page76036103p_a_ge
paise75028333p_aise
palazzi1742993palazzi
palazzo1743083palazzo
pale66055013p_a_le
pane64950293p_a_ne
panne76623653p_anne
panzer174213233p_anzer
parae76335703p_arae
pare66760843p_a_re
parge85831853p_arge
parle75836163p_arle
parse75236993p_arse
parve109824853p_arve
pase65346863p_a_se
passe75525693p_asse
paste74932953p_aste
pate65350463p_a_te
patzer173111643p_atzer
pause75021833p_ause
pave96133893p_a_ve
payee105524723p_ayee
pazazz1554023p_azazz
pazazzes1752343pazazzes
peace95026083pea_ce
peage84723573pea_ge
pease75231113pea_se
phage115113673pha_ge
phase104617213pha_se
pia56848033pia___
piaffed1693753piaffed
piaffer15104443piaffer
piaffes15115053piaffes
pial65636703pia__l
pian66136093pia__n
pianic103714123pianic
piano76118713pia_no
pianos84315933pianos
pians75126963pia_ns
pias66542553pia__s
piaster93012883piaster
piastre9307893piastre
picante11310523picante
pice84641093pi__ce
pickle144215653pickle
piddle103514913piddle
pie55457403pi___e
piece96717993pi_ece
pierce104010393pierce
piffle14418233piffle
piggie103210773piggie
pikake11115803pikake
pike106335213pi__ke
pile65649693pi__le
pilose84514243pilose
pilule8411123pilule
pimple123512963pimple
pine67755713pi__ne
pinene82915643pinene
pinite8321243pinite
pinkie124414273pinkie
pinnae84414643pinnae
pinole83218783pinole
pintle83818263pintle
pipage1199143pipage
pipe86434433pi__pe
pique16410173pi_que
pirate82322883pirate
piste75824603pi_ste
pixie145415523pi_xie
pizzas1646983pizzas
pizzaz1565443pizzaz
pizzazes1752513pizzazes
pizzazz0243023pizzazz
pizzazzes051143pizzazzes
pizzazzy071393pizzazzy
pizzles17329273pizzles
place94824613pla_ce
plage84520403pla_ge
plague93610853plague
plaice10311553plaice
plane74929143pla_ne
plaque17317643plaque
plate74635113pla_te
plaza164311063pla_za
plazas17409913plazas
pliable111610323pliable
praise84419413praise
prance104318573prance
prase76128753pra_se
prate75135983pra_te
prize164718943p_rize
puzzle16318603puzzle
raze135235433_ra_ze
razee145827803_razee
razz125219423_razz_
razzed15478283_razzed
razzes144910073_razzes
size135630963si__ze
sizzle14309613sizzle
smaze165012933sma_ze
snazzy1734013snazzy
spazz155811133spazz_
spazzes1735263spazzes
tazza1338083_tazza
teazle15329553teazle
tizzy16548893ti_zzy
upgaze1833543upga_ze
viable111613773viable
winze175014853wi_nze
wizzen17387203wi_zzen
wizzes175110773wi_zzes
zizzle13247313zizzle

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.406440125.6
2DLD Change Limit1127161754.87323130.7
3Display Results1751750.0632777.8
 (SQL Overall)1786911755.34233450.2
 
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.