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

227 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
perkish1625882(None) 
peakish16268871peakish
peckish18227291peckish
perish114619061per_ish
clerkish1744262clerkish
darkish1537942darkish
dervish1436982dervish
larkish1439082larkish
nerdish1137102nerdish
parish115022352par_ish
peevish1535782peevish
peris75537072per_is_
perkier133813122perkier
perkiest143313242perkiest
perkily1637812perkily
perking143716462perking
perks115325802perk_s_
persist9315852persist
pettish1238282pettish
pinkish16279112pinkish
puckish18237212puckish
punkish16257692punkish
serfish1348972serfish
sparkish17276972sparkish
weakish17217172weakish
beamish14259293beamish
bearish123013273bearish
beauish12268513beauish
bekiss1236373be_kiss
berks115423123berk_s_
bleakish1745053bleakish
bookish163610023bookish
buckish18237883buckish
burnish1238623burnish
carlish12312773carlish
ceorlish1345383ceorlish
cercis104614493cercis_
ceriph1398463cer_iph
cerise84822043cer_ise
cherish15310463cher_ish
cockish1838503cockish
currish1238353currish
deafish1438533deafish
delish105215613de_lish
dermis94717163dermis_
derris73615273derris_
dryish1336323_dryish
duskish1535183duskish
elfish1267963_elfish
elvish1277563_elvish
fermis114313503fermis_
fetish12310373fe_tish
folkish1736563folkish
freakish1845543freakish
furbish1536443furbish
furnish1337383furnish
garfish14179203garfish
garish104516923gar_ish
garnish111610843garnish
gawkish1835833gawkish
girlish1137193girlish
greyish1435173greyish
hawkish2036553hawkish
heimish1535463heimish
hellish13310723hellish
hennish1336863hennish
heroism12311013heroism
hickish1936473hickish
jerkier18407273jerkier
jerkies183411583jerkies
jerkiest19328113jerkiest
jerkily2134623jerkily
jerkin17258113jerki_n
jerking19308923jerking
jerkins18358253jerkins
jerks166514893jerk_s_
jewfish2343543jewfish
kermis124012393kermis_
largish1138603largish
leftish13197253leftish
marish114319053mar_ish
mawkish1935823mawkish
merks114722403merk_s_
monkish1638243monkish
nebbish1444253nebbish
nereis6315343nereis_
newish1237903ne_wish
oarfish13158613oarfish
ogreish1134673ogreish
ogrish1039263ogr_ish
overfish1737893overfish
palish114718273p_alish
panfish15229973panfish
pariah114320583par_iah
paris75145943par_is_
parkas125018023parkas_
parking143423043parking
parks116134463park_s_
parvis116114803parvis_
parvise124211693parvise
peakier134411443peakier
peakiest143513003peakiest
peaking144317693peaking
peaks114825623peak_s_
pearlash1344133pearlash
peckier153910523peckier
peckiest162711393peckiest
pecking164017783pecking
peckishly2342673peckishly
pecks135724433peck_s_
peeking144414953peeking
peeks115021113peek_s_
peise75825773pe__ise
pekes114623563pe_kes_
pekin111514423pe_ki_n
pekins121812233pe_kins
pelvis113610323pelvis_
penis75129323pe_nis_
pennis84315743pennis_
peonism11611103peonism
perch124518833per__ch
percuss1137163percuss
perdie94718513perdi_e
perdus93711273perdus_
pereia85217983perei_a
pereion9312053pereion
peres76246643per_es_
perfidy1635273perfidy
perfuse1247663perfuse
peri65636973per_i__
peril75425953per_i_l
perils84121853per_ils
period9314983per_iod
perished14310083per_ished
perishes13313753per_ishes
periti8319953per_iti
perk106232843perk___
perked134617693perk_ed
perkiness15209163perkiness
perky145319483perk__y
perlite9317323perlite
permian112612283permian
perming123416093perming
permit10321683permi_t
permits11314003permits
perms95524513per_ms_
pernio8513143perni_o
perps95521483per_ps_
perries93226603perries
perse75429523per__se
perses85428063perses_
persists1049183persists
pertest9317043pertest
perukes133210113perukes_
peruse84016843per_use
pervs105117373per_vs_
peskier13319113peskier
peskiest142610163peskiest
peskily1635083peskily
pigfish16217173pigfish
piggish14227703piggish
pikis115116393p_ikis_
pinfish15319303pinfish
pish96127913p___ish
pixyish2253653pixyish
planish12412053planish
plenish1239943plenish
polish114916723p_olish
poorish123712303poorish
popish133812113p_opish
porism104518063por_ism
porkier133712343porkier
porkies133416493porkies
porkiest143513713porkiest
porking143515813porking
porks115124143pork_s_
praise84419413p_raise
prankish1737023prankish
precis103416703precis_
precise113518173precise
premise113818553premise
premiss113513813premiss
previse123713793previse
prewash1535213prewash
prise74632613p_r_ise
prism94820263p_r_ism
priss74623893p_r_iss
prudish1376563prudish
publish1447913publish
puggish14265993puggish
punish111411503p_unish
pupfish1735533pupfish
puris75332023pur_is_
purism104715063pur_ism
purist85525053pur_ist
purplish1554933purplish
quirkish2442993quirkish
rakish134313963_rakish
rankish14510383rankish
reddish1238033reddish
redfish1437793redfish
relish93916953re_lish
reraise7316313reraise
rerise64325633rer_ise
selfish1388513selfish
serais64326133serais_
sickish1638423sickish
spearfish1743603spearfish
spookish1744643spookish
tarnish101611873tarnish
tartish101512633tartish
terais64023513terais_
varnish13169533varnish
verism113214263ver_ism
verist93823893ver_ist
vermis114214963vermis_
viperfish2042943viperfish
viperish1655893viper_ish
warmish1538373warmish
weakfish2143523weakfish
wearish132310153wearish
wennish1336243wennish
wettish1335963wettish
wormish1537163wormish
yerking15368813yerking
yerks125416563yerk_s_
zerks185113823zerk_s_

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 Limit1340272276.36021073.4
3Display Results2272270.0762986.8
 (SQL Overall)1786912276.84226116.8
 
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.