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

120 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
quackiest243518(None) 
quakiest2138581qua_kiest
duckiest153211862du_ckiest
luckiest143011442lu_ckiest
muckiest163210912mu_ckiest
quackier23215372quackie_r
quackish2654382quacki_sh
quackism2543512quacki_sm
quaggiest2044172quaggiest
qualmiest2044392qualmiest
quickest2345342quick_est
quickies2336772quickies_
quirkiest2234372quirkiest
suckiest143314102su_ckiest
tackiest143112432_tackiest
wackiest172610272_wackiest
whackiest2144982whackiest
yuckiest17328832yu_ckiest
achiest12315183__achiest
backrest1639393_backrest
balkiest144112453_balkiest
barkiest144115153_barkiest
baulkiest1544233baulkiest
beachiest1638443beachiest
beakiest143313463bea_kiest
blackest16269303black_est
blockiest1736363blockiest
brakiest143912243bra_kiest
brickiest1737433brickiest
bulkiest143511263bu_lkiest
bunchiest1635663bunchiest
cakiest133215663_ca_kiest
chalkiest1837083chalkiest
clankiest1536663clankiest
cockiest163013293_cockiest
crackliest1844883crackliest
crankiest1538823crankiest
dickiest153412503_dickiest
duckies143613813du_ckies_
duskiest133710083du_skiest
flakiest153210543fla_kiest
flockiest1835643flockiest
funkiest152810973fu_nkiest
gawkiest16327313_gawkiest
gunkiest132610573gu_nkiest
hackies163418243_hackies_
hackliest1836523_hackliest
hulkiest15329713hu_lkiest
hunkiest153812333hu_nkiest
huskiest153210413hu_skiest
ickiest133611043__ickiest
jackies202912623_jackies_
juiciest1736923juic_iest
junkiest192610173ju_nkiest
kickiest13319673_kickiest
laciest93819033_lac_iest
lakiest113517263_la_kiest
lankiest122912493_lankiest
larkiest123713313_larkiest
leachiest1437243leachiest
leakiest123212793lea_kiest
luckies133313683lu_ckies_
murkiest143210263mu_rkiest
muskiest143311553mu_skiest
oakiest112913923_oa_kiest
paciest112917803_pac_iest
pawkiest17277883_pawkiest
peachiest1638523peachiest
peakiest143512993pea_kiest
peckiest162711393_peckiest
pickiest162712593_pickiest
pluckiest1735293pluckiest
poachiest1636883poachiest
pockiest163412053_pockiest
prickiest1748183prickiest
punchiest1636453punchiest
punkiest149312663pu_nkiest
quacked2336793quack_e_d
quackeries2544313quackeries_
quackery2633113quack_ery
quacking2436743quacki_ng
quackisms2642273quackisms
quacks214710103quack__s_
quaintest1845343quaintest
quakes194013343qua_k_es_
quakier20239203qua_kie_r
quakiness2236073qua_kiness
quarries1749943quarries_
queasiest1844313queasiest
queaziest2743243queaziest
quickie2235513quickie__
quickness2443723quickness
quickset2345363quickse_t
quicksets2442383quicksets
quippiest2243983quippiest
raciest92820013_rac_iest
rockiest142912223_rockiest
sarkiest123615063_sarkiest
sauciest10310963sauc_iest
shakiest151910933sha_kiest
skankiest12145703skankiest
slackest14289393slack_est
snakiest122110533sna_kiest
snarkiest13207623snarkiest
spaciest122310893spac_iest
sparkiest15188093sparkiest
squabbiest2342843squabbiest
squalliest1944123squalliest
squashiest2244113squashiest
squattiest1944223squattiest
squeakiest2342773squeakiest
stalkiest1347903stalkiest
stickiest15229603stickiest
stockiest15207753stockiest
sulkiest124212493su_lkiest
swankiest16136203swankiest
talkiest123611223_talkiest
trickiest1549023trickiest
wackest164710863_wack_est
yukkiest14214533yu_kkiest

Search took 9 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 Filter1786911486410.1731032896.0
2DLD Change Limit1486411208.62617231.7
3Display Results1201200.0462608.7
 (SQL Overall)1786911208.84520202.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.