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

158 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
perkinesses174892(None) 
jerkinesses2246051jerkinesses
peskinesses1746571peskinesses
porkinesses1748771porkinesses
corkinesses1749212corkinesses
dorkinesses1647662dorkinesses
eerinesses10612602eer_inesses
forkinesses1848002forkinesses
geekinesses1635812geekinesses
germinesses1437882germinesses
larkinesses1538992larkinesses
leakinesses1538472leakinesses
merrinesses1358262merrinesses
murkinesses17136782murkinesses
nerdinesses1249052nerdinesses
nervinesses1437322nervinesses
pawkinesses2036152pawkinesses
peppinesses1435312peppinesses
perkiness15209162perkine_s_s
pertnesses12310312per_tnesses
pettinesses1338632pettinesses
pickinesses1996832pickinesses
pokinesses1669612p_okinesses
punkinesses17127222punkinesses
pursinesses1338742pursinesses
airinesses102613613air_inesses
artinesses10815213_artinesses
balkinesses1767503balkinesses
beadinesses1449563beadinesses
beefinesses1675953beefinesses
beerinesses1398923beerinesses
boskinesses17136813boskinesses
bulkinesses1786483bulkinesses
burlinesses1338403burlinesses
cakinesses16310613_cakinesses
cheekinesses2164203cheekinesses
cockinesses1947563cockinesses
corninesses13410593corninesses
creakinesses1845993creakinesses
curlinesses1338733curlinesses
darknesses1537013dark_nesses
dewinesses1438353de_winesses
dirtinesses1239883dirtinesses
duskinesses16136843duskinesses
earlinesses11311043earlinesses
easinesses10314443_easinesses
edginesses1236703_edginesses
fervidnesses1943843fervidnesses
fierinesses1439233fier_inesses
flakinesses1837073flakinesses
flukinesses1836093flukinesses
freakinesses1945593freakinesses
funkinesses18137003funkinesses
furrinesses1437183furrinesses
gawkinesses1935633gawkinesses
gemminesses1634983gemminesses
gorinesses11311553gor_inesses
hardinesses151110223hardinesses
headinesses1539843headinesses
heartinesses1548003heartinesses
heavinesses1747453heavinesses
heftinesses1737133heftinesses
hokinesses1758943_hokinesses
horninesses1459003horninesses
horsinesses1439553horsinesses
huskinesses18136533huskinesses
hyperkineses2453613hyperkine_ses
ickinesses1637183_ickinesses
inkinesses1439423_inkinesses
jerkiness20175643jerkine_s_s
jettinesses1836383jettinesses
jokinesses2147533_jokinesses
kinkinesses1435873kinkinesses
kookinesses1435373kookinesses
lankinesses1539013lankinesses
leafinesses1437873leafinesses
leerinesses11119483leerinesses
legginesses1345293legginesses
luckinesses1746653luckinesses
mealinesses13310973mealinesses
meatinesses13311983meatinesses
meeknesses1644803meek_nesses
messinesses1297513messinesses
milkinesses1786793milkinesses
mirinesses121512313mir_inesses
muskinesses17127043muskinesses
needinesses1258103needinesses
newsinesses1436323newsinesses
packnesses1856633pack_nesses
paperinesses1646053paper_inesses
pastinesses13911713pastinesses
peakednesses1945043peakednesses
peartnesses1338743peartnesses
pertinences1545743pertinences
peskiness15216523peskine_s_s
phoninesses1636453phoninesses
pigginesses1555613pigginesses
pinknesses1636583pink_nesses
pipinesses1448603p_ipinesses
pithinesses1637503pithinesses
pixinesses1937373p_ixinesses
pluckinesses2043993pluckinesses
porkiness15249193porkine_s_s
portlinesses1446993portlinesses
pottinesses1339103pottinesses
preppinesses1544883preppinesses
prettinesses1447543prettinesses
primnesses1497803p_rimnesses
princesses14206263p_r_incesses
prosinesses13310853prosinesses
pudginesses1545053pudginesses
puffinesses1934513puffinesses
pugginesses1545253pugginesses
pulpinesses1536003pulpinesses
puninesses121110753p_uninesses
purenesses12810743pur_enesses
pushinesses1697333pushinesses
quakinesses2436323quakinesses
quirkinesses2542893quirkinesses
readinesses12611273readinesses
reedinesses1259563reedinesses
riskinesses1537833riskinesses
rockinesses1737363rockinesses
seaminesses13310753seaminesses
seedinesses1259203seedinesses
sexinesses1739213se_xinesses
shakinesses1837613shakinesses
silkinesses1557903silkinesses
smokinesses1736253smokinesses
snakinesses1538553snakinesses
sneakinesses1645903sneakinesses
sorrinesses11310093sorrinesses
speedinesses1545593speedinesses
spikinesses1746523spikinesses
spookinesses1844093spookinesses
sportinesses1447873sportinesses
spunkinesses1844383spunkinesses
sulkinesses1557723sulkinesses
surlinesses11310053surlinesses
tackinesses1737253tackinesses
talkinesses1537353talkinesses
tardinesses121110253tardinesses
tarrinesses11129083tarrinesses
tartinesses111011503tartinesses
tearinesses11311693tearinesses
tersenesses1149043tersenesses
testinesses111210323testinesses
wackinesses2036653wackinesses
warinesses131514523war_inesses
weaklinesses1944483weaklinesses
weaknesses1735463weak_nesses
wearinesses14310213wearinesses
weedinesses1557073weedinesses
weepinesses1646133weepinesses
wirinesses131811523wir_inesses
wordinesses15138883wordinesses
worminesses16127993worminesses
yuckinesses2044763yuckinesses

Search took 6 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 Filter1786911216330.390458182.1
2DLD Change Limit1216331585.28023036.6
3Display Results1581580.0961645.8
 (SQL Overall)1786911585.76630990.5
 
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.