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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

89 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
pizzaz156544(None) 
pizazz1554221pizazz
pizza1538181pizza_
pizzas1646981pizzas
pizzazz0243021pizzazz
pazazz1554022pazazz
piazza1643822piazza_
piazzas1743642piazzas
pizazzy1952242pizazzy
pizzazes1752512pizzazes
pizzazzy071392pizzazzy
pizzle16279492pizzle
bezazz1543983bezazz
bizzes163910843bizzes
dizzy177410853dizz_y
epizoa1745013epizoa_
fizz157519823fi_z_z
fizzed18369443fizzed
fizzer17369383fizzer
fizzes174512553fizzes
fizzle17369713fizzle
fizzy199015083fizz_y
gizzard17114203gizzard
hazzan17236803hazzan
huzza1646093huzza_
huzzah2044423huzzah
huzzas1735863huzzas
izar136616013_i_zar
izzard15135243_izzard
mirza16410443mirza_
mirzas1738173mirzas
mizzen16447953mizzen
mizzle16279993mizzle
mizzly19256103mizzly
nizam16310253ni_zam
pia56848033pi__a_
pial65636703pi__al
pian66136093pi__an
pias66542553pi__as
piazze1634683piazze
pibal95217323pi_bal
pica85831493pi_ca_
pical95524373pi_cal
picas94626523pi_cas
pickax2135913pickax
pieta75421753pieta_
pietas84516503pietas
pika106322953pi_ka_
pikas114218093pi_kas
pilaf103923483pi_laf
pilar75221503pi_lar
pilau73618523pi_lau
pilaw103913743pi_law
pilea75123953pilea_
pillar8314023pillar
pima85428653pi_ma_
pimas94725103pi_mas
pina65842633pi_na_
pinas75434453pi_nas
pineal84817683pineal
pinna75320183pinna_
pinnae84414643pinnae
pinnal84814273pinnal
pinnas85315513pinnas
pinta75727053pinta_
pintas85021393pintas
pipal95118353pi_pal
pita65436433pi_ta_
pitas77427673pi_tas
pitman102412123pitman
pitsaw1135613pitsaw
pitta75018693pitta_
pittas86014523pittas
pizazzes1742373pizazzes
pizzazzes051143pizzazzes
pizzles17329273pizzles
plaza164311063plaza_
plazas17409913plazas
puzzle16318603puzzle
sizar145214993si_zar
sizzle14309613sizzle
tazza1338083tazza_
tazzas1436273tazzas
tizzy16548893tizz_y
wizzen17387203wizzen
wizzes175110773wizzes
zigzag1642963zigzag
zizzle13247313zizzle
zzz1017911913__zz_z

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 Filter1786911127160.1401276364.3
2DLD Change Limit112716896.72016773.2
3Display Results89890.0461934.8
 (SQL Overall)178691896.90625874.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.