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

81 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
piazzas174364(None) 
piazza1643821piazza_
pizzas1646981pi_zzas
piazze1634682piazz_e
pizazzes1742372pizazzes
pizza1538182pi_zza_
pizzaz1565442pi_zzaz
plazas17409912pla_zas
tazzas1436272_tazzas
baizas173810823_baizas
bizzes163910843bi_zzes
brazas175812433bra_zas
chazzan20204853chazzan
chazzans21234503chazzans
diazins1739183diazins
fizzes174512553fi_zzes
hamzas20119013_hamzas
hazzan17236803_hazzan
hazzans18215783_hazzans
huzzas1735863_huzzas
jazzes21347883_jazzes
kwanzas2342053kwanzas
lianas63713383lia_nas
matzas1749703_matzas
miasmas1167743miasmas
mirzas1738173mi_rzas
pacas96029403p_a_cas
pachas135017143p_achas
paisas84317493p_aisas
palazzos1842553palazzos
pampas124913993p_ampas
pandas95521963p_andas
pangas99921103p_angas
papas94927493p_a_pas
paras76143043p_a_ras
parkas125018023p_arkas
pashas115117063p_ashas
pastas85422873p_astas
pazazz1554023p_azazz
pazazzes1752343pazazzes
piaffes15115053piaffes
pianos84315933pia_nos
pians75126963pia__ns
pias66542553pi___as
piasabas1243883piasabas
piasavas1343333piasavas
picaras11311273picaras
picas94626523pi__cas
pietas84516503pi_etas
pikas114218093pi__kas
pimas94725103pi__mas
pinas75434453pi__nas
pinatas93711483pinatas
pinnas85315513pi_nnas
pintas85021393pi_ntas
piraguas1144453piraguas
piranas9912603piranas
piranhas13135873piranhas
pirayas1277483pirayas
pitas77427673pi__tas
pitayas1286263pitayas
pittas86014523pi_ttas
pizazz1554223pizaz_z
pizazzy1952243pizazzy
pizzazes1752513pizzazes
pizzazz0243023pi_zzazz
pizzazzes051143pizzazzes
pizzle16279493pi_zzle
pizzles17329273pizzles
plasmas113010753plasmas
playas114612283pla_yas
plaza164311063pla_za_
prajnas1635453prajnas
razzes144910063_razzes
riatas63915083ria_tas
spazzes1735263spazzes
stanzas1636363stanzas
tazza1338083_tazza_
tiaras6314533tia_ras
wizzes175110773wi_zzes
zanzas1487053_zanzas

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 Filter1786911340270.186960704.3
2DLD Change Limit134027816.78319759.3
3Display Results81810.0302700.0
 (SQL Overall)178691816.99925530.9
 
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.