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

117 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
quirkiest223437(None) 
mirkiest142910252_mirkiest
murkiest143210262mu_rkiest
quackiest2435182quackiest
quakiest2138582qu_akiest
quickest2345342quick_est
quickies2336772quickies_
quippiest2243982quippiest
quirkier2134162quirkie_r
quirkiness2342822quirkiness
quirkish2442992quirki_sh
smirkiest1535192smirkiest
squirmiest2142772squirmiest
airiest74221013_air_iest
barkiest144115153_barkiest
birkies133712433_birkies_
brickiest1737433brickiest
bulkiest143511263bu_lkiest
burliest103113053bu_rliest
burriest102911213bu_rriest
chinkiest1867023chinkiest
chirkest1735383chirk_est
chirpiest16286473chirpiest
corkiest143114793_corkiest
curdiest112511393cu_rdiest
curliest102713113cu_rliest
curviest13309673cu_rviest
dickiest153412503_dickiest
dinkiest133812873_dinkiest
dirtiest93014203_dirtiest
dorkiest133111253_dorkiest
duckiest153211863du_ckiest
duskiest133710083du_skiest
firriest112310433_firriest
flirtiest1236183flirtiest
forkiest153812303_forkiest
friskiest1636233friskiest
funkiest152810973fu_nkiest
furriest112910793fu_rriest
furziest20267783fu_rziest
girliest93010403_girliest
guiltiest1035713guiltiest
gunkiest132610573gu_nkiest
hairiest11612463hair_iest
hinkiest153311753_hinkiest
hulkiest15329713hu_lkiest
hunkiest153812333hu_nkiest
huskiest153210413hu_skiest
ickiest133611043__ickiest
inkiest113415043__inkiest
jerkiest19328113_jerkiest
juiciest1736923jui_ciest
junkiest192610173ju_nkiest
kickiest13319673_kickiest
kinkiest113110503_kinkiest
larkiest123713313_larkiest
luckiest143011443lu_ckiest
milkiest142911083_milkiest
miriest93619823_mir_iest
mirkest13309723_mirk_est
muckiest163210913mu_ckiest
murkest133110203mu_rk_est
muskiest143311553mu_skiest
perkiest143313243_perkiest
pickiest162712593_pickiest
porkiest143513713_porkiest
prickiest1748183prickiest
punkiest149312663pu_nkiest
pursiest102812123pu_rsiest
purtiest102414113pu_rtiest
quaggiest2044173quaggiest
qualmiest2044393qualmiest
quarries1749943quarries_
queasiest1844313queasiest
queaziest2743243queaziest
queries16315873quer_ies_
querist16311133quer_i_st
quickie2235513quickie__
quickness2443723quickness
quickset2345363quickse_t
quicksets2442383quicksets
quietest1757173qui_etest
quietist1767493quieti_st
quinsies1737623quinsies_
quires154015733quir__es_
quirked21325423quirk_e_d
quirkily2442583quirki_ly
quirking22215123quirki_ng
quirks19419113quirk__s_
riskiest12310133_riskiest
sarkiest123615063_sarkiest
shirtiest1239323shirtiest
silkiest123212853_silkiest
slinkiest13188073slinkiest
snarkiest13207623snarkiest
sparkiest15188093sparkiest
spikiest14259533spi_kiest
spiriest102513453spir_iest
squeakiest2342773squeakiest
squiffiest2542653squiffiest
squinniest1943413squinniest
squintiest1944983squintiest
squishiest2244313squishiest
stickiest15229603stickiest
stinkiest13198463stinkiest
suckiest143314103su_ckiest
sulkiest124212493su_lkiest
surfiest112414423su_rfiest
surliest82416903su_rliest
swirliest1236283swirliest
trickiest1549023trickiest
turfiest112410123tu_rfiest
twirliest1234503twirliest
whirliest15216043whirliest
wiriest103816853_wir_iest
yuckiest17328833yu_ckiest
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.1561145455.1
2DLD Change Limit1486411178.43617619.8
3Display Results1171170.1101063.6
 (SQL Overall)1786911178.70220534.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.