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 “panicky” 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
panicky183385(None) 
finicky1943712finicky
panic93923902panic__
panicked1785172panicked
panicle11129982panicle
panics103815362panic_s
panicum1346392panicum
picky165416942p__icky
picnicky2142172picnicky
pricky174210342p_ricky
antick124814583_antick_
anticks134612253_anticks
anticly12410053_anticly
bricky17489093_bricky
colicky1835783colicky
dicky154816243__dicky
fancify1834983fancify
fancily1538253fancily
fancy134615483fan_c_y
finnicky2042213finnicky
garlicky1842123garlicky
hanky155418293han__ky
icky136315753___icky
jacky215412343ja__cky
kicky135012333__kicky
laniary1068013laniary
lanky125517483lan__ky
manic94629443manic__
manics103919933manic_s
nancy105214923nan_c_y
nick106627603__nick_
nicks114920493__nicks
pacey126720283pa__cey
pacify1667473paci_fy
pack125535443pa__ck_
packly17228333pa__ckly
packs135528933pa__cks
pacy115328683pa__c_y
paik105726803pa_i_k_
paiks114719853pa_i_ks
painch133511323painc_h
painty114714753pa_inty
panacea1137783panacea
panache1458423panache
pancake1536673pancake
pandy115021173pan__dy
panfry14456413pan_fry
panically16310433panically
panickier1743173panickier
panicking1835293panicking
panicled13106783panicled
panicles121010113panicles
panicums1444743panicums
panier84425503pani_er
paniers94717333paniers
panini8314273pani_ni
panino8315683pani_no
panocha1444983panocha
panoche1456383panoche
panoply1434713panoply
pansy105717973pan__sy
pantry115014103pan_try
panty105929303pan__ty
papacy1547493papac_y
parity114719873pari_ty
patchy16509573pa_tchy
paucity1435823paucity
paunchy17324443paunchy
pawky173810153pa__wky
peacocky2142453peacocky
pecky165515093p__ecky
penicil1138833penicil
pianic103714123pianic__
pick125933813p__ick_
picks135226143p__icks
pinky145823403p__inky
plasticky2043593plasticky
plisky1533713p_lisky
plucky17406583p_lucky
pocky165314603p__ocky
policy133211513polic_y
pricey134412633p_ricey
prick134317503p_rick_
prickly18367893p_rickly
pricks144414263p_ricks
pricy124814563p_ric_y
punchy16398523pun_chy
punily11311773puni_ly
punky144419393pun__ky
sanicle91210263sanicle
sanity9316203sani_ty
shticky19344473shticky
snick114416013_snick_
snicks124312473_snicks
staticky1743233staticky
sticky154711343_sticky
tacky145617443ta__cky
talcky15294723ta_lcky
tricky154211473_tricky
vanity12311933vani_ty
wacky174714933wa__cky
zanily18310183zani_ly
zincky24404963zin_cky

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.1601116818.8
2DLD Change Limit1340271036.51320578.4
3Display Results1031030.0333121.2
 (SQL Overall)1786911036.70626646.4
 
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.