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

301 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
pizzas164698(None) 
piazzas1743641piazzas
pizza1538181pizza_
pizzaz1565441pizzaz
bizzes163910842bizzes
fizzes174512552fizzes
huzzas1735862huzzas
mirzas1738172mirzas
pias66542552pi__as
piazza1643822piazza_
picas94626522pi_cas
pietas84516502pietas
pikas114218092pi_kas
pimas94725102pi_mas
pinas75434452pi_nas
pinnas85315512pinnas
pintas85021392pintas
pitas77427672pi_tas
pittas86014522pittas
pizazz1554222pizazz
pizzazes1752512pizzazes
pizzazz0243022pizzazz
pizzle16279492pizzle
pizzles17329272pizzles
plazas17409912plazas
tazzas1436272tazzas
wizzes175110772wizzes
baizas173810823baizas
bias64738153bi__as
bimas95521743bi_mas
biogas94310913biogas
biotas84313923biotas
bizes165923663bi_zes
brazas175812433brazas
buzzes165011173buzzes
colzas174010503colzas
cozzes164510893cozzes
dipsas9359893dipsas
ditas65923673di_tas
ditzes163212423ditzes
divas95418583di_vas
dizens164911393dizens
dizzies16279753dizzies
dizzy177410853dizz_y
epizoa1745013epizoa_
fezzes174910403fezzes
fincas113512063fincas
fizz157519823fizz__
fizzed18369443fizzed
fizzer17369383fizzer
fizzers18357003fizzers
fizzle17369713fizzle
fizzles18339063fizzles
fizzy199015083fizz_y
frizzes18338183frizzes
fuzzes175412253fuzzes
gigas75415583gi_gas
gizmos1844133gizmos
gizzard17114203gizzard
gizzards18133263gizzards
gyozas1933603gyozas
hamzas20119013hamzas
hazzan17236803hazzan
hazzans18215783hazzans
hijras1635773hijras
huzza1646093huzza_
huzzah2044423huzzah
huzzahs2143083huzzahs
ideas65919013_ideas
iotas54821113_iotas
isbas71010393_isbas
ixias12488363_ixias
izar136616013_i_zar
izars145112933_izars
izzard15135243_izzard
izzards16143963_izzards
jazzes21347883jazzes
kiblas1239323kiblas
kinas95626913ki_nas
kivas124614733ki_vas
lezzes14387833lezzes
lianas63713383lianas
libras83711703libras
limas75627633li_mas
limbas105313193limbas
limpas105513083limpas
lingas75116563lingas
liras56021983li_ras
litas54923773li_tas
matzas1749703matzas
mezuzas1743233mezuzas
mezzos1635043mezzos
micas96823053mi_cas
milpas101710273milpas
minas75434113mi_nas
mirza16410443mirza_
mizens174610253mizens
mizunas1843693mizunas
mizzen16447953mizzen
mizzens17366123mizzens
mizzle16279993mizzle
mizzles17329493mizzles
mizzly19256103mizzly
ninjas1386303ninjas
nipas77116673ni_pas
nizam16310253ni_zam
nizams1735413nizams
pacas96029403p_acas
pachas135017143pachas
paisas84317493paisas
pampas124913993pampas
pandas95521963pandas
pangas99921103pangas
papas94927493p_apas
paras76143043p_aras
parkas125018023parkas
pas58775743p___as
pashas115117063pashas
pastas85422873pastas
pazazz1554023pazazz
peas65755063p__eas
phizes20389133phizes
pia56848033pi__a_
pial65636703pi__al
pian66136093pi__an
pianos84315933pianos
pians75126963pi_ans
piazze1634683piazze
pibal95217323pi_bal
pibals103813083pibals
pica85831493pi_ca_
pical95524373pi_cal
picaras11311273picaras
pickax2135913pickax
picks135226143pi_cks
picots104616443picots
pics85633913pi__cs
piculs103511753piculs
pieces104217273pieces
piers75926333pi_ers
pies66949603pi__es
pieta75421753pieta_
pignus937953pignus
pigs76634223pi__gs
pika106322953pi_ka_
pikers124717393pikers
pikes115031033pi_kes
pikis115116393pi_kis
pilaf103923483pi_laf
pilafs113511023pilafs
pilar75221503pi_lar
pilau73618523pi_lau
pilaus84114133pilaus
pilaw103913743pi_law
pilaws11399433pilaws
pilea75123953pilea_
piles74742613pi_les
pileus84514943pileus
pilis75825203pi_lis
pillar8314023pillar
pillars9313483pillars
pills74130973pi_lls
pilots84018873pilots
pilous84717743pilous
pilus75921063pi_lus
pima85428653pi_ma_
pimps114616983pi_mps
pina65842633pi_na_
pinatas93711483pinatas
pineal84817683pineal
pineals93212843pineals
pines76048863pi_nes
pingos95317673pingos
pings85830883pi_ngs
pinkos125313873pinkos
pinks115729383pi_nks
pinna75320183pinna_
pinnae84414643pinnae
pinnal84814273pinnal
pinons86019943pinons
pinots85920273pinots
pins65558453pi__ns
pinta75727053pinta_
pintos86021293pintos
pints75936223pi_nts
pinups1037413pinups
pions75826393pi_ons
pious74621273pi_ous
pipal95118353pi_pal
pipals104213643pipals
pipers104318663pipers
pipes96030143pi_pes
pipets105714773pipets
pipits104713063pipits
pips85837133pi__ps
piques1739093piques
piranas9912603piranas
pirayas1277483pirayas
pirns76020093pi_rns
pis56362033pi___s
piscos105112593piscos
pishes114722103pishes
pisos76021063pi_sos
piss65033333pi__ss
pisses84525083pisses
pistes85325633pistes
pita65436433pi_ta_
pitayas1286263pitayas
piths105817543pi_ths
pities83828083pities
pitman102412123pitman
pitmans11188743pitmans
pitons85319043pitons
pits66348743pi__ts
pitsaw1135613pitsaw
pitsaws1234993pitsaws
pitta75018693pitta_
pivots115111903pivots
pixels15478533pixels
pixes144323173pi_xes
pixies154915513pixies
pizazzes1742373pizazzes
pizazzy1952243pizazzy
pizzazzes051143pizzazzes
pizzazzy071393pizzazzy
pizzerias1942163pizzerias
playas114612283playas
plaza164311063plaza_
pleas75627033p_leas
polkas1239103polkas
poppas93710713poppas
prezes173614693prezes
primas104418103primas
prizers183911843prizers
prizes173819813prizes
proas75028803p_roas
psoas75012983p_soas
pujas145513323p_ujas
pumas95121563p_umas
punas74826753p_unas
punkas123410673punkas
pupas95219283p_upas
purdas92612263purdas
putzes174212523putzes
puzzle16318603puzzle
puzzles17318973puzzles
pyas96225703p__yas
quizzes2435573quizzes
razzes144910063razzes
rias45540593ri__as
riatas63915083riatas
riojas1335813riojas
ritzes154812943ritzes
sigmas94111353sigmas
sikas94617023si_kas
silvas92912183silvas
simas75727553si_mas
sirras63814863sirras
sizar145214993si_zar
sizars154812623sizars
sizers155215813sizers
sizes146727763si_zes
sizzle14309613sizzle
sizzles15349633sizzles
spazzes1735263spazzes
spicas104715823spi_cas
spireas94412513spireas
spitzes1849173spitzes
tazza1338083tazza_
tiaras6314533tiaras
tibias839943tibias
tikkas934523tikkas
tineas64616473tineas
tizzies15287893tizzies
tizzy16548893tizz_y
vigas94817883vi_gas
vigias104110893vigias
villas96117263villas
vinas85126343vi_nas
vincas113912453vincas
violas93713523violas
virgas1048883virgas
visas84317653vi_sas
vistas94513273vistas
vivas114815023vi_vas
vizirs18306713vizirs
vizors18328903vizors
vizslas1943143vizslas
whizzes2134713whizzes
wiccas1336543wiccas
winzes184313053winzes
wizens186110263wizens
wizes174723343wi_zes
wizzen17387203wizzen
wizzens18385483wizzens
zanzas1487053zanzas
zas126946833___zas
zigzag1642963zigzag
zigzags1742273zigzags
zizzle13247313zizzle
zizzles14307093zizzles

Search took 9 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.1561145455.1
2DLD Change Limit1127163017.81314426.7
3Display Results3013010.1102736.4
 (SQL Overall)1786913018.07922118.0
 
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.