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

91 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
piazza164382(None) 
piazzas1743641piazzas
piazze1634681piazze
pizza1538181pi_zza
pizazz1554222pizazz
pizazzy1952242pizazzy
pizzas1646982pi_zzas
pizzaz1565442pi_zzaz
plaza164311062pla_za
tazza1338082_tazza
baiza164813223_baiza
braza165214253bra_za
chazzan20204853chazzan
diazin1639163diazin
diazo15310033dia_zo
dizzy177410853di_zzy
epizoa1745013epi_zoa
fizz157519823fi_zz_
fizzy199015083fi_zzy
hamza19139773_hamza
hazzan17236803_hazzan
huzza1646093_huzza
jazz193714463_jazz_
jazzy23396363_jazzy
kwanza2232473kwanza
liana53915893lia_na
matza16311813_matza
miasma1097563miasma
mirza16410443mi_rza
paca85132243p_a_ca
pacha126518063p_acha
paisa76021073p_aisa
palazzi1742993palazzi
palazzo1743083palazzo
palea75028663p_alea
pampa114913423p_ampa
panda85022613p_anda
panga85323533p_anga
papa85827143p_a_pa
para65242173p_a_ra
parka115120883p_arka
pasha105417183p_asha
pasta76624533p_asta
pazazz1554023p_azazz
pia56848033pi___a
piaffe1494913piaffe
pial65636703pia__l
pian66136093pia__n
pianic103714123pianic
piano76118713pia_no
pianos84315933pianos
pians75126963pia_ns
pias66542553pia__s
piasaba1144193piasaba
piasava1243883piasava
pica85831493pi__ca
picara10311903picara
pieta75421753pi_eta
pika106322953pi__ka
pilea75123953pi_lea
pima85428653pi__ma
pina65842633pi__na
pinata83817213pinata
pineta85815563pineta
pinna75320183pi_nna
pinta75727053pi_nta
piragua1044643piragua
pirana8713263pirana
piranha12126363piranha
piraya1167713piraya
pita65436433pi__ta
pitaya1186603pitaya
pitta75018693pi_tta
pizazzes1742373pizazzes
pizzazz0243023pizzazz
pizzazzy071393pizzazzy
pizzle16279493pizzle
plasma103810913plasma
playa105812943pla_ya
plazas17409913plazas
prajna1535073prajna
razz125219423_razz_
riata54618023ria_ta
snazzy1734013snazzy
spazz155811133spazz_
stanza1537073stanza
tazzas1436273_tazzas
tazze1339573_tazze
tiara5315903tia_ra
tizzy16548893ti_zzy
zanza1378703_zanza

Search took 8 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 Limit112716917.66014714.9
3Display Results91910.0137000.0
 (SQL Overall)178691917.81322871.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.