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 “feistily” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

96 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
feistily144526(None) 
feistier1136192feistier
feisty12449292feist__y
fishily1637642f_ishily
flintily1434892flintily
friskily1834502friskily
frostily1436692frostily
fustily133111382f_ustily
mistily122612342_mistily
testily102910802te_stily
yeastily1444572yeastily
zestily19167562ze_stily
beastly1277563beast_ly
bristly12178063brist_ly
chestily1645523chestily
crispily1574693crispily
crustily13328173crustily
daintily1245523daintily
deistic10311173deisti_c
destiny113111463de_stiny
dirtily1138583_dirtily
distil73616433_distil_
distill83011323_distill
distils83015803_distils
dustily113211533_dustily
easily9313023_eas_ily
emptily1445813_emptily
faintly1337083faint_ly
fattily13379463f_attily
faultily1474523faultily
feasibly1644743feasibly
feasting122011323feasting
featly123711753fe_at_ly
feinting123410833feinting
feist86230073feist___
feistiest1237073feistiest
feists94915313feist__s
fertile10311733fe_rtile
festal94213563fe_stal_
festally1437543fe_stally
festive1339773fe_stive
festively1845773fe_stively
fetidly1435013fe__tidly
fictile1238023f_ictile
fierily1339023f_ierily
fifthly1943093f_ifthly
filmily1535733f_ilmily
filthily1743663f_ilthily
firstly1335643first_ly
fissile10269653f_issile
fistic11812573f_isti_c
fisting113818123f_isting
fistula1045503f_istula
fitly115114973f_i_t_ly
flashily1735473flashily
fleshily1744533fleshily
flightily1943353flightily
flimsily1643283flimsily
flossily1434523flossily
foisting122910503foisting
frizzily2253143frizzily
fruitily1445153fruitily
fussily13267613f_ussily
gristly11187333grist_ly
grittily1244183grittily
guiltily1243423guiltily
gustily113010903_gustily
hastily133010663_hastily
heartily1436563heartily
heftily1635763he_ftily
heisting123411043heisting
lustily103611243_lustily
meatily12311093me_atily
messily12298813me_ssily
moistly1236613moist_ly
mustily123613633_mustily
nastily103011033_nastily
niftily1335753_niftily
noisily1038403nois_ily
peskily1635083pe_skily
pettily1238173pe_ttily
pistil83915073_pistil_
pistils93314303_pistils
prissily1346693prissily
redistill1044503redistill
riskily1436413_riskily
rustily103112993_rustily
shiftily1744553shiftily
tastily103311643_tastily
testify13246943te_stify
thirstily1542693thirstily
thistly1395963thist_ly
trustily11257103trustily
weightily1942463weightily
wispily1535653_wispily
wittily1336173_wittily

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.423422437.4
2DLD Change Limit146162967.01620832.7
3Display Results96960.0303200.0
 (SQL Overall)178691967.46923924.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.