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

103 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
paranoid1131114(None) 
paranoia10410561paranoia
paranoic1249831paranoic
paranoids1248911paranoids
pyranoid1447281pyranoid
araneid8310802_araneid
carangid1246422carangid
carangoid1344512carangoid
parafoil1345972parafoil
paranoea1048572paranoea
paranoiac1346262paranoiac
paranoias11410442paranoias
paranoics1347652paranoics
paranoidal1354892paranoidal
parotoid11410032parotoid
pyrenoid1446872pyrenoid
acaroid103512313_acaroid
adenoid959253_adenoid
agatoid948623_agatoid
arachnoid1544513_arachnoid
aramid93315613_ara_mid
araneids947743_araneids
aroid65428343_ar__oid
carabid12311333cara_bid
carangids1344573carangids
carcinoid1465673carcinoid
cardioid1247453cardioid
catenoid1149113catenoid
ceratoid1149923ceratoid
coracoid1348163coracoid
coronoid1148953coronoid
crinoid1039943_crinoid
ganoid8314443__ganoid
humanoid1445713humanoid
hyracoid1745973hyracoid
keratoid1347273keratoid
lianoid837533_lianoid
manatoid1148823manatoid
marasmoid1443293marasmoid
melanoid1147123melanoid
parabola1246653parabola
parabolic1546283parabolic
paraboloid1554083paraboloid
paraded114014263para_ded
parador103311413parado_r
paradors113411903paradors
parados103816053parado_s
paradox17358173parado_x
paraffin1644903paraffin
parafoils1445503parafoils
paraform1546933paraform
paraglide1345703paraglide
paragoge1257153paragoge
paragon10311023parago_n
paragoned1357063paragoned
paragons11311503paragons
paramo102614643paramo__
paramos113213513paramo_s
paramour1246083paramour
parang93715513paran__g
parangs104314373paran_gs
paranoeas1147523paranoeas
paranoiacs1444253paranoiacs
parapodia1445513parapodia
parasail1049233parasail
parasitoid13114533parasitoid
parasol939553paraso_l
parasoled1246353parasoled
parasols1039263parasols
parazoan1946553parazoan
parboil1138323par_boil
pardoned12189333pardoned
parented11912213parented
parodoi10267723parodoi_
parotid102915513par_otid
parotoids1256963parotoids
parsnip1146323parsn_ip
parsonic1239703parsonic
peracid12312993pera_cid
percoid12312323per_coid
pernod9310453per_no_d
petaloid1148753petaloid
pharaonic1645763pharaonic
placoid1239773p_lacoid
platinoid1244863platinoid
pranced123714043p_ranced
pranged114512553p_ranged
pranked143712093p_ranked
puranic11410483puran_ic
pyralid1347983pyra_lid
pyramid1547513pyra_mid
pyranose1344923pyranose
pyranoside1653143pyranoside
pyrenoids1544803pyrenoids
rancid9513863__rancid
ranid66429333__ran_id
sarcoid10310453sar_coid
scaraboid1443753scaraboid
serranoid1045203serranoid
sparoid102311543spar__oid
tabanid1047333taban_id
teratoid9411073teratoid
tetanoid947203tetanoid

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.423422437.4
2DLD Change Limit1461621038.01618233.8
3Display Results1031030.0462239.1
 (SQL Overall)1786911038.48521059.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.