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

56 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
facilely164436(None) 
agilely1135122_agilely
docilely1443992docilely
facetely1643852facetely
facially1637642facially
facile112514882facile__
facility1638242facility
fragilely1662432fragilely
futilely1444082futilely
tactilely1443432tactilely
acidly125211793_aci_dly
actively1647063_actively
acutely1246123_acutely
affinely1743863affinely
bacilli1146393bacil_li
bailey115015673ba_ile_y
cicely1338833__cicely
datively1545673datively
ductilely1543563ductilely
faceless13269173faceless
faciae112913413faciae__
facial113615633faci_al_
facials123310743faci_als
faciend1334803faci_end
facies113921593faci_e_s
faculty1535573facul_ty
failed105421603fa_ile_d
faille93414743fa_il_le
failles102914133fa_illes
faintly1337083fa_intly
fairly125610013fa_i_rly
fallibly1644393fallibly
falsely1336013fa_lsely
family143311703fami__ly
fanciless1444603fanciless
fancily1538253fanci__ly
fatally1339893fatal_ly
felinely1445953felinely
fertilely1544273fertilely
fictively2044603fictively
filly114424903f__il_ly
finely123011563f__inely
finitely1445663finitely
focally15188553focal_ly
frailly1337313frail_ly
frilly124111443f_ril_ly
lacily11612763laci__ly
naively1335903na_ively
natively1446413natively
palely11311933pa__lely
racially1339623racially
racily11715173raci__ly
senilely1146113senilely
tacitly1236223taci_tly
vilely1239443__vilely
virilely1444053virilely

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.436409841.7
2DLD Change Limit146162566.64022012.3
3Display Results56560.0331697.0
 (SQL Overall)178691567.10925135.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.