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

97 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
papistic144873(None) 
papist102618742papist__
papistry1543722papistry
papists112110452papist_s
patristic1389272patristic
pianistic1347172pianistic
puristic1239382puristic
sadistic1148372sadistic
abiotic11510453_abiotic
anapestic1346313anapestic
anisic8313793_anis_ic
aoristic10311163aoristic
aphetic142912853_aphetic
aphotic142913113_aphotic
aplastic1249243aplastic
aplitic11311743_aplitic
apostil947903_apostil
aprotic112715233_aprotic
artistic10310893artistic
atavistic1445983atavistic
autistic10310103autistic
aviatic1239243_aviatic
ballistic1346613ballistic
casuistic1344943casuistic
caustic1139753ca_ustic
cladistic1445683cladistic
cubistic1445703cubistic
dadaistic1344803dadaistic
deistic10311173_deistic
diaristic1247483diaristic
dualistic1246103dualistic
egoistic1147103egoistic
ekistic1377843_ekistic
eristic9814093_eristic
fascistic1644593fascistic
faunistic1444473faunistic
fistic11812573__fistic
haptic13511883hap__tic
holistic13311263holistic
imagistic1445113imagistic
jaditic1746703jadi_tic
juristic1746133juristic
karstic1357983ka_rstic
logistic1147823logistic
majestic1944913majestic
mastic103119173ma__stic
meristic12311253meristic
monistic12311303monistic
narcistic1346443narcistic
nastic82915973na__stic
nomistic1279593nomistic
onanistic1147373onanistic
pacific1646913paci_fic
pacifistic1953823pacifistic
panmictic1744483panmictic
panoptic1447183panoptic
papism122211513papis__m
papisms13238543papis_ms
papistries1445193papistries
parasitic1349523parasitic
paretic113016673pa_retic
parodistic1546793parodistic
parotic112518033pa_rotic
pastie85525523pa__stie
pastil85018323pa__stil
pastis84924323pa__stis
pathetic15410943pathetic
patriotic13107573patriotic
patristics14105773patristics
pelitic111814653peli_tic
peptic122113153pep__tic
periotic12313443periotic
pharisaic1644633pharisaic
pietistic1346303pietistic
pistil83915073__pistil
plastic112815063p_lastic
poditic122611583podi_tic
politic112918713poli_tic
poplitic14510013poplitic
populistic1644853populistic
protistic13410983protistic
pyritic143311313pyri_tic
rabietic1245503rabietic
rapist82520673rapist__
rapists92510753rapist_s
realistic1148553realistic
sophistic1647313sophistic
spastic11310373_spastic
statistic1147133statistic
taxitic1637093taxi_tic
theistic1348153theistic
tropistic1347213tropistic
truistic1046903truistic
utopistic1345383utopistic
veristic1339883veristic
wapiti1138363wapi_ti_
wapitis1236473wapi_tis

Search took 9 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.1561145455.1
2DLD Change Limit146162977.81318707.5
3Display Results97970.0631539.7
 (SQL Overall)178691978.03222247.4
 
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.