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

147 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
quickies233677(None) 
quickie2235511quickie_
dickies143416342_dickies
duckies143613812du_ckies
hickies163614742_hickies
luckies133313682lu_ckies
quackier23215372quackier
quackiest2435182quackiest
quiches2139332quic_hes
quicken2235152quick_en
quickens2334252quickens
quicker2247022quick_er
quickest2345342quick_est
quicklimes2751862quicklimes
quickness2443732quickness
quicks21389302quick__s
quickset2345362quickset
quicksets2442382quicksets
quinsies1737622quinsies
quirkier2134162quirkier
quirkiest2234372quirkiest
sickies133717502_sickies
stickies142211972stickies
bikies124515163_bi_kies
birkies133712433_birkies
brickier16307163brickier
brickiest1737433brickiest
brickles162810283brickles
buckles153416093bu_ckles
buckoes153810393bu_ckoes
chickees19258513chickees
chuckies1937703chuckies
dickie133913113_dickie_
dickier143512453_dickier
dickiest153412503_dickiest
dinkies123716033_dinkies
duchies133312313du_chies
duckie133511663du_ckie_
duckier143911793du_ckier
duckiest153211863du_ckiest
equities17310773equi_ties
eurokies1246333eurokies
hackies163418243_hackies
hickie153812473_hickie_
huckles163612623hu_ckles
hunkies143214503hu_nkies
huskies143212083hu_skies
ickier12439923__ickier
ickiest133611043__ickiest
jackies202912623_jackies
juices1549423juic__es
juicier1635463juic_ier
juiciest1736923juic_iest
junkies183711693ju_nkies
kickier12349053_kickier
kickiest13319673_kickiest
luckie123611413lu_ckie_
luckier133811533lu_ckier
luckiest143011443lu_ckiest
mickles153415003_mickles
muckier153411483mu_ckier
muckiest163210913mu_ckiest
muckles153413253mu_ckles
munchies1539253munchies
muskies133614673mu_skies
nickles133713823_nickles
outcries10313573outcries
pickier153912973_pickier
pickiest162712593_pickiest
pickles153215443_pickles
pinkies133818263_pinkies
pliskies1475973pliskies
prickier16368143prickier
prickiest1748183prickiest
prickles162511093prickles
punkies134216803pu_nkies
quacked2336793quack_ed
quackeries2544313quackeries
quacking2436743quacking
quackish2654383quackish
quackism2543513quackism
quackisms2642273quackisms
quacks214710103quack__s
quaiches2235343quaic_hes
quakes194013343qu_ak_es
quakier20239203qu_akier
quakiest2138583qu_akiest
quarries1749943quarries
queries16315873qu_eries
quibbles2134223quibbles
quiche2057903quic_he_
quick204311063quick___
quickened2543163quickened
quickener2443123quickener
quickeners2542763quickeners
quicklime2641823quicklime
quickly2534073quick_ly
quickstep2651713quickstep
quicksteps2751483quicksteps
quinaries1857873quinaries
quinces183210433qui_nces
quinines172410203quinines
quinins162811293qui_nins
quinoids1845693quinoids
quinones17227753quinones
quinsied1845043quinsied
quintes164114713qui_ntes
quintics19266983quintics
quintiles1845983quintiles
quintins17329863quintins
quippier2133773quippier
quippiest2243983quippiest
quires154015753qui__res
quirked21325433quirk_ed
quirkily2442593quirkily
quirkiness2342823quirkiness
quirking22215123quirking
quirkish2442993quirkish
quirks19419113quirk__s
quitches2236193quitches
quixotes2443553quixotes
quizzes2435573qui_zzes
ruckles133414603ru_ckles
sickees134514213_sickees
sickie123715743_sickie_
sickles133417543_sickles
sicklies14710013_sicklies
silkies113715693_silkies
squinnies1844483squinnies
stickier14229763stickier
stickiest15229603stickiest
stickles142512103stickles
suckier133613973su_ckier
suckiest143314113su_ckiest
suckles134516743su_ckles
suicides1139083suicides
sulkies114315763su_lkies
tickles133416853_tickles
trickie132611033trickie_
trickier143010233trickier
trickiest1549023trickiest
trickles143013763trickles
twinkies1535983twinkies
vichies15310623_vichies
whiskies1835953whiskies
yuckier16358533yu_ckier
yuckiest17328833yu_ckiest

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.406440125.6
2DLD Change Limit1461621477.12320519.7
3Display Results1471470.0632333.3
 (SQL Overall)1786911477.59223536.7
 
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.