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

142 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
frilliest123711(None) 
chilliest14358912chilliest
fillies103420252f_illies_
filmiest1338552f_ilmiest
frillier1136512frillie_r
fringiest1347602fringiest
friskiest1636232friskiest
frizziest20294142frizziest
frizzliest21132932frizzliest
grisliest1047352grisliest
hilliest113914112_hilliest
silliest84017102_silliest
stilliest939222stilliest
bilgiest11309883_bilgiest
billies93923503_billies_
braillist1146193brailli_st
brawliest14177193brawliest
brickiest1737433brickiest
brilliant1145683brilliant
briniest102812323bri_niest
bristliest1245143bristliest
brollies1039533brollies_
bulliest104314503_bulliest
childliest1653863childliest
chillest13259593chill_est
chillies134113483chillies_
crawliest14187403crawliest
crimpiest15237183crimpiest
crinkliest16104523crinkliest
crispiest13197423crispiest
dillies84122163_dillies_
drawliest13166243drawliest
driftiest1335943driftiest
drippiest1445363drippiest
drizzliest19122533drizzliest
drollest937353droll_est
drooliest1036343drooliest
drumliest1235433drumliest
evillest1146353evill_est
failles102914133faill_es_
faultiest1236093faultiest
featliest1238363featliest
feistiest1237073feistiest
fellest10313753f_ell_est
fellies104119743f_ellies_
fieriest112112243f_ieriest
filles94224523f_ill_es_
fillet95027083f_ill_e_t
fillets103414753f_ill_ets
fillips12298133f_illips_
filthiest1545373f_ilthiest
finniest113011403f_inniest
firriest112310433f_irriest
fishiest14310453f_ishiest
fizziest19226073f_izziest
fliest94718433f___liest
flimsiest1434463flimsiest
flintiest1248433flintiest
flirtiest1236193flirtiest
folkiest15319503f_olkiest
follies103618943f_ollies_
frailest1139493frail_est
frailties1245853frailties_
freakiest16206693freakiest
freckliest1943383freckliest
frettiest1267063frettiest
friaries11310083friaries_
friendliest1552263friendliest
frilled113911603frill_e_d
friller104111743frill_e_r
frillers11349873frill_ers
frilling123011493frilli_ng
frillings13265803frillings
frills94414223frill__s_
frizzies19315933frizzies_
froggiest1434913froggiest
frostiest1239213frostiest
frothiest1537453frothiest
frouziest2143973frouziest
frowsiest1535063frowsiest
frowziest2443483frowziest
fruitiest1237383fruitiest
frumpiest1634543frumpiest
fullest10313343f_ull_est
gainliest1037133gainliest
ghillies12408663ghillies_
gillies84120963_gillies_
girliest93010403_girliest
grilles83715023grill_es_
grimiest11299823gri_miest
gripiest11289633gri_piest
grippiest1435143grippiest
gristliest1154983gristliest
grittiest10176983grittiest
grizzliest19152823grizzliest
growliest1335583growliest
guiltiest1035713guiltiest
illest63615723__ill_est
jolliest152910363_jolliest
killies113318113_killies_
milkiest142911083_milkiest
miltiest103015173_miltiest
oiliest72817683_oi_liest
palliest102814633_palliest
priciest122112903pri_ciest
prickiest1748183prickiest
prickliest1845293prickliest
prissiest11178903prissiest
priviest132310313pri_viest
rallies73823343_rallies_
ribbiest1237583_ribbiest
ridgiest1038903_ridgiest
rilles64725503_rill_es_
rillet64828853_rill_e_t
rillets74216153_rill_ets
rimiest93215853_ri_miest
rippliest1334763_rippliest
riskiest12310133_riskiest
ritziest17237843_ritziest
roiliest8312283_roiliest
ruliest72816433_r_uliest
shelliest1238023shelliest
shrillest1245393shrill_est
silkiest123212853_silkiest
sillies73425083_sillies_
siltiest83515613_siltiest
smelliest1136603smelliest
stillest8311073still_est
swirliest1236293swirliest
trickiest1549023trickiest
trickliest1646433trickliest
trilbies1037693trilbies_
trippiest1336583trippiest
trollies8310233trollies_
twirliest1234503twirliest
whirliest15216043whirliest
wiliest103416593_wi_liest
willies103920153_willies_
woolliest1235853woolliest
wriggliest1542933wriggliest
wrinkliest1743833wrinkliest
wristiest1237753wristiest

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.423422437.4
2DLD Change Limit1486411427.31320325.6
3Display Results1421420.0602366.7
 (SQL Overall)1786911427.79622920.9
 
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.