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

55 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
papadams1510478(None) 
papadam1486911papadam_
papadoms1575921papadoms
papadums1573851papadums
pappadams1542141pappadams
macadams1545092macadams
panadas103312212panada_s
papadom1466762papadom_
papadum1475232papadum_
papayas1437272papaya_s
pappadam1443232pappadam_
anadems1036143_anadems
apparats1287093apparats
bemadams1543383bemadams
faradays1544273faradays
hamadas1339673hamada_s
macadam1446853macadam_
madams11310943__madams
napalms1144033napa_lms
pachadoms1943623pachadoms
pagandoms1543123pagandoms
pagodas11367553pagoda_s
pajamas18278153pajama_s
paladins11911003paladins
palapas11311493palapa_s
palatals1037773palatals
panada94113053panada__
panamas113112763panama_s
pandas95521963pa_nda_s
pangrams1337153pangrams
papacies1439473papacies
papains11312363papa_ins
papas94927493pap__a_s
papaws13419113pap__aws
papaya1337503papaya__
papayan1445303papaya_n
paphians1545593paphians
papisms13238543pap_isms
paraders113113113paraders
parades104121463parad_es
paradigms1544653paradigms
paradors113411903paradors
parados103816053parad_os
pardahs13289673pa_rdahs
pashadoms1743453pashadoms
patacas11311003pataca_s
patamars1246843patamars
paydays1634433pa_ydays
popedoms1545283popedoms
poppadoms1572583poppadoms
poppadums1571993poppadums
posadas1037193posada_s
praams10459643p_ra_ams
ramadas1039303ramada_s
salaams997703sala_ams

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 Filter1786911461620.423422437.4
2DLD Change Limit146162556.81321453.4
3Display Results55550.0134230.8
 (SQL Overall)178691557.24924650.4
 
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.