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

107 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
prankish173702(None) 
crankish1736511crankish
rankish14510381_rankish
brackish1987612brackish
brandish1469022brandish
orangish1246552orangish
panfish15229972p_anfish
peakish16268872pea_kish
pinkish16279112p_inkish
planish12412052plan_ish
pranking153813382pranking
prankishly2242412prankishly
pranks124814722prank_s_
punkish16257692p_unkish
rakish134313962_ra_kish
ankush13114433__ankush
banish111416043_ban_ish
blackish1976713blackish
blandish1497003blandish
brainish1338813brainish
branks124817383brank_s_
brassish1346433brassish
brattish1346973brattish
brinish1239963brin_ish
clannish1345263clannish
crankest1438143crankest
crankier14339163crankier
crankiest1538823crankiest
crankily1755623crankily
cranking154613073cranking
cranks125015313crank_s_
crawfish1944233crawfish
crayfish1944253crayfish
cronish12310863cron_ish
danish101513793_dan_ish
darkish1537943_darkish
draffish1844553draffish
dronish1138913dron_ish
evanish1337653evan_ish
frankest1536963frankest
franking164310863franking
franks134912733frank_s_
freakish1845543freakish
garnish111610843garn_ish
gawkish1835833_gawkish
grayfish1844483grayfish
grayish1437813gra_yish
hawkish2036553_hawkish
larkish1439083_larkish
mannish121710693_mannish
mawkish1935823_mawkish
monkish1638243_monkish
paganish1447773pagan_ish
palish114718273p_a_lish
parish115022353p_a_rish
peckish18227293p_eckish
perkish16258823p_erkish
pianism11611033pian_ism
pianist9615103pian_ist
pinfish15319303p_infish
planking153513013planking
planks124116753plank_s_
plenish1239943plen_ish
practise12310143practise
praise84419413pra__ise
prances113618773prances_
prancing132612163prancing
prandial1149643prandial
pranging123012723pranging
prangs94816233pran_gs_
prank115019453prank___
pranked143712093prank_ed
praxis154012253pra_xis_
priggish1544683priggish
prinking153212453prinking
prinks124315383prink_s_
prudish1376563pr_udish
puckish18237213p_uckish
punish111411503p_un_ish
quackish2654383quackish
radish103516913_ra_dish
raffish1658843_raffish
rakis95323443_ra_kis_
rammish1437563_rammish
ranis55235833_ran_is_
rankest112713813_rankest
ranking124320883_ranking
ranks95225733_rank_s_
raspish1298103_raspish
ratfish1338773_ratfish
rattish10510823_rattish
ravish123414033_ra_vish
rawish123012913_ra_wish
runtish1048693_runtish
sparkish17276973sparkish
standish1238543standish
tannish101610573_tannish
tarnish101611873tarn_ish
trampish1535653trampish
tranks104017763trank_s_
trickish1746793trickish
trunkfish1941723trunkfish
uranism91112513uran_ism
vanish121513213_van_ish
varnish13169533varn_ish
weakish17217173wea_kish
zanyish2235903_zanyish

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 Limit1461621076.70321805.5
3Display Results1071070.0462326.1
 (SQL Overall)1786911077.17224915.1
 
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.