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

172 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
filmily153573(None) 
balmily14216462balmily
family143311702f_amily
fierily1339022fierily
filly114424902fil__ly
filmi105914002filmi__
filmic13348452filmi_c
filmier1237502filmier
filming133210352filming
filmis114610282filmi_s
filmy136114042film__y
filthily1743662filthily
firmly1436662firm_ly
fishily1637642fishily
flimsily1643282flimsily
foamily1546542foamily
milkily16216552milkily
oilily93111722oil_ily
silkily14236962silkily
sillily10209782sillily
slimily1247712slimily
wilily123310762wil_ily
airily93014823ai_rily
balkily16266693balkily
beamily1477393beamily
billy105525363bil__ly
bulkily16227123bulkily
calmly1337613calm_ly
chillily1644113chillily
dilly94923783dil__ly
dimity12310473di_mity
dimly114913483di_m_ly
dimply14339743di_mply
dingily1238103dingily
dirtily1138583dirtily
dizzily1934843dizzily
doomily1336133doomily
fallibly1644393fallibly
falsely1336013falsely
falsify1643613falsify
falsity1335903falsity
fancily1538253fancily
fattily13379463fattily
faultily1474523faultily
feistily1445263feistily
felly114922803fel__ly
fibril1137163fibril_
fibrils1236843fibrils
fickly18318533fi_ckly
fictile1238023fictile
fiddly14328483fi_ddly
fifthly1943093fifthly
filial93013253fil_ial
filially1447003filially
filing103823763fil_ing
fill75540193fil__l_
fille84327403fil__le
fillies103420253fillies
filling113520803filling
fillip11268953filli_p
fillips12298133fillips
fillo84319783fil__lo
fills84632373fil__ls
film94828173film___
filmable15157133filmable
filmdom1562943filmdom
filmed124610363film_ed
filmer114112403film_er
filmers124211293filmers
filmically2044933filmically
filmiest1338553filmiest
filmlike1734443filmlike
films105617963film__s
filmset1257513filmset
filthy15356423fil_thy
fimble133611753fi_mble
finally13310103finally
finely123011563fi_nely
firefly1635633firefly
firming132811223firming
firstly1335643firstly
fissile10269653fissile
fitly115114973fi__tly
fixedly2133913fixedly
fixity19427803fi_xity
flail85316183f_lail_
flails94313003f_lails
flakily1736293flakily
flatly123110213f_latly
flimsy14345563flim_sy
flintily1434893flintily
fluidly1434813f_luidly
flukily1735213flukily
foggily1535053foggily
folksily1843443folksily
folly115022603fol__ly
foxily1947253f_oxily
frilly124111443fril__ly
friskily1834503friskily
frizzily2253143frizzily
frumpily1843323frumpily
fuggily1534963fuggily
fulfil1246423fulfil_
fulfill1345023fulfill
fulfils1345723fulfils
fully114820863ful__ly
fulmine1257963fulmine
funkily1736513funkily
funnily1336373funnily
furmity1535183furmity
furrily1337613furrily
fussily13267603fussily
fustily133111373fustily
fuzzily2145073fuzzily
gamily123712183_gamily
gemmily1534603gemmily
giddily1335073giddily
gilly94321633gil__ly
gluily10308293_gluily
grimily1336523grimily
guiltily1243423guiltily
hammily1736063hammily
hilly114422163hil__ly
holily123612953hol_ily
homily144712333_homily
icily101211693_i_cily
ickily1535753_ickily
illy76925333_il__ly
imply124911843_i_mply
jiminy1836273ji_miny
jimminy2133373jimminy
jimply20397483ji_mply
jollily1745773jollily
joltily1746323joltily
kinkily1335223kinkily
lily76730183__l_ily
limply133810033li_mply
mildly12318243mil_dly
mirkily16266403mirkily
mistily122612343mistily
niftily1335753niftily
nimbly13388773ni_mbly
nippily1444713nippily
pimply15329213pi_mply
pithily1567033pithily
pulpily1436103pulpily
riskily1436413riskily
ritzily1945143ritzily
roomily1237283roomily
saltily10310543saltily
silly84527623sil__ly
simile83115633si_mile
simply133010523si_mply
slily85820033_sl_ily
slimly11408903slim_ly
sulkily14218113sulkily
swimmily1842713swimmily
tidily102811393ti_dily
timely113410113ti_mely
timidly1334593ti_midly
tinily94014433ti_nily
tinnily1047363tinnily
tipsily1236043tipsily
uglily1036193ugl_ily
vilely1239443vil_ely
vilify1536773vil_ify
wildly13328123wil_dly
willy115321913wil__ly
windily1437943windily
wirily123310783wi_rily
wispily1535653wispily
wittily1336173wittily

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 Filter1786911340270.423422437.4
2DLD Change Limit1340271727.04619021.7
3Display Results1721720.0632730.2
 (SQL Overall)1786911727.53223724.2
 
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.