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

91 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
filially144700(None) 
facially1637642facially
filial93013252filia_l_
filmically2044932filmically
finally13310102fi_nally
finically1747952finically
fiscally1646072fiscally
unfilially1653482unfilially
aerially11911913aerially
axially1737233_axially
biaxially2143693biaxially
biblically1945063biblically
biliary1238213bilia_ry
ciliary1247923cilia_ry
ciliately1443963ciliately
civically1946563civically
civilly1535483civi_lly
clinally1347233clinally
digitally1445663digitally
dismally1446513dismally
distally1239553distally
failingly1636133failingly
familiarly1852913familiarly
fatally1339893f_atally
faunally1445433faunally
felinely1445953felinely
festally1437543festally
feudally1554823feudally
fiducially1952143fiducially
figurally1643633figurally
fileable13179223fileable
filiate10414233filia_te
filiated12610083filiated
filiates11412663filiates
fillable13179573fillable
filly114424903f__i_lly
filmable15157133filmable
filmily1535733fil_mily
filthily1743663filthily
finial92814183finia_l_
finialed1255503finialed
finials103210153finia_ls
finitely1445663finitely
fitfully1744993fitfully
flatly123110213f_l_atly
florally1447033florally
fluidally1643163fluidally
focally15188553f_ocally
formally1638243formally
frailly1337313frai_lly
friarly13316213f_riarly
frilly124111443f_ri_lly
frugally1544403frugally
fugally1435603f_ugally
genially12129523genially
helically1749433helically
ideally1137793_ideally
ilial55317843_ilia_l_
initially1249063initially
jovially2144753jovially
labially1336983labially
leally94012613__leally
lineally1137793lineally
medially14129323medially
menially131111093menially
mesially13119083mesially
miliary1249463milia_ry
minimally1645903minimally
misally121111063mi_sally
officially2143453officially
oilily93111723oili__ly
pitiably1545843pitiably
pliably14147383_pliably
pulpally1544453pulpally
racially1339623racially
radially1239783radially
reliably1339243reliably
ritually1167483ritually
serially11912843serially
signally1246533signally
socially1338543socially
telically1449853telically
tidally1137933ti_dally
trivially1545143trivially
uncially1339073uncially
venially1499423venially
virally1339653vi_rally
visually1465493visually
vitally1339673vi_tally
wilfully1743753wilfully
wilily123310763wili__ly

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.420425454.8
2DLD Change Limit146162917.47019566.5
3Display Results91910.0461978.3
 (SQL Overall)178691917.93622516.5
 
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.