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

122 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
kingliest143652(None) 
jingliest1735971jingliest
kindliest1436111kindliest
tingliest1047681tingliest
dangliest1137172dangliest
dingiest102915372ding_iest
gangliest1137672gangliest
giggliest1234322giggliest
jangliest1746382jangliest
jiggliest1854182jiggliest
jungliest1744922jungliest
kingless13288692kingl_ess
kinglet123114042kingl_e_t
kinglets13318582kingl_ets
kinglier1345632kinglie_r
kingliness1543952kingliness
kinkiest113110502kin_kiest
lingiest93715262ling_iest
mingiest113315822ming_iest
niggliest1144932niggliest
tangliest1068422tangliest
tinkliest1336132tinkliest
wiggliest1444882wiggliest
wingiest123214282wing_iest
zingiest182810892zing_iest
angriest9310253_angriest
auntliest936323auntliest
bilgiest11309883bilg_iest
clingiest1257133cling_iest
crinkliest16104523crinkliest
dimpliest1436583dimpliest
dinghies1347363dinghies_
dingies93618243ding_ies_
dingles93818323dingl_es_
dinkiest133812873din_kiest
dungiest102810743dung_iest
finalist113014733finali_st
finniest113011403fin_niest
fringiest1347603fring_iest
gainliest1037133gain_liest
gingelies11277503gingelies_
ginniest92610513gin_niest
girliest93010403gi_rliest
goggliest1234063goggliest
hilliest113914113hi_lliest
hinkiest153311753hin_kiest
hungriest1344543hungriest
ingest73119003_ing__est
ingles74420873_ingl_es_
inkiest113415043_in_kiest
jiggiest17277693ji_ggiest
jingles153816383jingl_es_
jinglier1655233jinglie_r
jingoist16126263jingoi_st
kickiest13319673ki_ckiest
killies113318113ki_llies_
kindest12311503kin__dest
kindles123614843kindl_es_
kindless13289243kindl_ess
kindlier1345763kindlie_r
kindliness1544043kindliness
kingfish1944493kingfi_sh
kinglike1235093kingli_ke
kingpins1544903kingpins_
kingpost1544423king_post
kingsides1543853kingsides_
kinless113310273kin_l_ess
kittlest12297573kittl_est
knurliest1344073knurliest
likeliest1346123likeliest
linguist948573lingui_st
liniest73321153lin__iest
lintiest82715913lin_tiest
liveliest1247093liveliest
loneliest949443loneliest
mangiest112815903mang_iest
manliest102314943man_liest
minciest122913113min_ciest
mingles103719003mingl_es_
mintiest103217143min_tiest
oiliest72817683oi__liest
piggiest12259663pi_ggiest
pimpliest1545473pimpliest
piniest93121133pin__iest
rangiest93115983rang_iest
ridgiest1038903ridg_iest
ringlet82818173ringl_e_t
ringlets92910233ringl_ets
rippliest1334763rippliest
saintliest1046013saintliest
sickliest1547523sickliest
silliest84017103si_lliest
singles83520433singl_es_
singlet84120113singl_e_t
singlets93611473singl_ets
skinniest1335523skin_niest
spangliest1345153spangliest
spindliest1344483spindliest
stingiest10209773sting_iest
swingiest13207573swing_iest
tangiest92915223tang_iest
timeliest1147233timeliest
tingles83818323tingl_es_
tinglier956403tinglie_r
tiniest73020123tin__iest
tinniest82911463tin_niest
ugliest8410153__ugliest
unkindliest1652653unkindliest
viniest103216613vin__iest
waggliest1434783waggliest
wifeliest1545883wifeliest
wiggiest13269013wi_ggiest
wiliest103416593wi__liest
windiest122213233win_diest
wingless122910023wingl_ess
winglet113115983wingl_e_t
winglets12299593wingl_ets
winiest103419693win__iest
wintriest1238153wintriest
wiseliest1237723wiseliest
wriggliest1542933wriggliest
wrinkliest1743833wrinkliest

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 Filter1786911486410.453394461.4
2DLD Change Limit1486411227.18620684.8
3Display Results1221220.0631936.5
 (SQL Overall)1786911227.70223200.6
 
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.