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

78 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
papayan144530(None) 
papaya1337501papaya_
papayas1437271papayas
papadam1486912papadam
papain10313792papa_in
paphian1437452paphian
abaya104413173_abaya_
abayas114011703_abayas
apian75018333_ap_ian
apparat11711713apparat
ataman81013063_ataman
banyan1139483ba_nyan
capelan1139003capelan
capstan1137903capstan
captan101613343cap_tan
caravan1239233caravan
japan14411233jap__an
kabaya15387123kabaya_
kabayas16316803kabayas
mayan105616903__mayan
packman1736693packman
paean77222723__paean
paesan85114093pa_esan
pagan86121163__pagan
paisan84417073pa_isan
pajama17317653pajama_
pajamas18278153pajamas
paladin101011773paladin
palapa10310673palapa_
palapas11311493palapas
palatal9310153palatal
pampean1335543pampean
panacean1244733panacean
panada94113053panada_
panadas103312213panadas
panama104213353panama_
panamas113112763panamas
papa85827143pap__a_
papacy1547493papa_cy
papadams15104783papadams
papadom1466763papadom
papadum1475233papadum
papains11312363papains
papal95820673pap__al
papally1437973papally
papas94927493pap__as
papaw125112493pap__aw
papaws13419113papa_ws
paphians1545593paphians
pappadam1443233pappadam
pappy114713803pappy__
papula103011113papula_
papulae11249353papulae
papular11299763papular
papyral1445773papyral
papyri1334903pap_yri
papyrian1544563papyrian
paragon10311023paragon
parasang1147333parasang
paravane1348103paravane
parazoan1946553parazoan
parian83223963pa_rian
partan83820563pa_rtan
pataca10311193pataca_
patacas11311003patacas
patamar1147093patamar
pattypan1541863pattypan
pavan106518473__pavan
piraya1167713piraya_
pirayas1277483pirayas
pitaya1186603pitaya_
pitayas1286263pitayas
platan83913693p_latan
playa105812943p_laya_
playas114612283p_layas
sabayon1244233sabayon
sagaman10117563sagaman
yatagan1144133yatagan

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.406440125.6
2DLD Change Limit134027787.08018930.4
3Display Results78780.0302600.0
 (SQL Overall)178691787.51623774.7
 
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.