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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

112 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
paphian143745(None) 
paphians1545591paphians
apian75018332_ap_ian
papain10313792papai_n
papayan1445302papayan
papyrian1544562papyrian
parian83223962pa_rian
raphia113511262raphia_
raphias123511082raphias
aphelian1376963_aphelian
aphid115515393_aphi_d
aphidian1445533_aphidian
aphids125110843_aphids
aphis105917133_aphi_s
ashcan1135843_ashcan
ashman1148383_ashman
avian84616053_a_vian
banian8315383ba_nian
capelan1139003capelan
capias10318353cap_ias
caplin103216303capli_n
capstan1137903capstan
captain112111063captain
captan101613343cap_tan
caption113513693caption
cyprian1445343cyprian
daphnia1345053daphnia_
daphnias1444683daphnias
dauphin1344383dauphi_n
fashion1337843fashion
japan14411233jap__an
kachina1637663kachina
kalian10312163ka_lian
lapin75222923lap_i_n
magian9312833ma_gian
martian93514683martian
napkin1236903napki_n
orphan1137733orph_an
pacha126518063pach_a_
pachas135017143pach_as
pachisi14329523pachisi
packman1736693packman
paction112713963paction
paean77222723pa__ean
paesan85114093pa_esan
pagan86121163pa__gan
pagurian1144613pagurian
pain65647243pa__i_n
paisan84417073pa_isan
pallia83015593pallia_
pallial92911253pallial
pampean1335543pampean
panhuman1544003panhuman
papa85827143pap__a_
papadam1486913papadam
papains11312363papains
papal95820673pap__al
papas94927493pap__as
papaw125112493pap__aw
papaya1337503papaya_
papayas1437273papayas
papism122211513pap_ism
papist102618743pap_ist
pappi84810893pappi__
pappier103511593pappier
pappies103214823pappies
paprica1337003paprica
papricas1447053papricas
paprika1544003paprika
paprikas1643853paprikas
papula103011113papula_
papulae11249353papulae
papular11299763papular
papyral1445773papyral
pariah114320583pa_riah
parians93519733pa_rians
partan83820563pa_rtan
partial92616263partial
partisan1058423partisan
partizan1955643partizan
pasha105417183pash_a_
pashas115117063pash_as
pashing135120513pashing
pashmina1543313pashmina
passion9310883passion
pastina93914593pastina
pathway1844853pathway
patin76832853pa_ti_n
patina86022193pa_tina
paulin8312983pauli_n
pavan106518473pa__van
pavin105623203pa_vi_n
pechan13511543pech_an
pepsin10310853pepsi_n
permian112612283permian
phial10313203__phial
pian66136093__p_ian
pipkin14248603pipki_n
pippin92810303pippi_n
pluvian1245333pluvian
poplin10413483popli_n
rachial122012173rachial
radian74117273ra_dian
raphae114311733raph_ae
raphide13138073raphide
raphis114014323raphi_s
salpian938493salpian
saphead1357773saphead
saphena1235863saphena
saurian739913saurian
syrphian1643453syrphian
zaptiah2144293zaptiah

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271126.06322105.7
3Display Results1121120.0462434.8
 (SQL Overall)1786911126.51527427.6
 
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.