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

45 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
docilely144399(None) 
docile94213122docile__
docility1447122docility
ductilely1543562ductilely
facilely1644362facilely
agilely1135123_agilely
bovinely1664423bovinely
cicely1338833__cicely
concisely1645323concisely
datively1545673datively
decibel1235993decibel_
decibels1344523decibels
decidedly1743513decidedly
decile94619213decile__
deciles104417713decile_s
dilly94923783d__il_ly
direly10311553d__irely
divinely1544993divinely
doctorly1443113doctorly
doiled84817293do_ile_d
doily95321033do_i__ly
dolly96125203do__l_ly
dopily123510463dopi__ly
dotingly1337343dotingly
doucely1344883do_ucely
doyley13487283do_yle_y
dozily19329103dozi__ly
ducally13257413ducal_ly
focally15188553focal_ly
futilely1444083futilely
hostilely1543313hostilely
jocosely2042763jocosely
locally12179723local_ly
oilily93111723_o_ilily
politely1347083politely
senilely1146093senilely
sociably1546793sociably
socially1338533socially
society1236083soci_ety
solely93714213so__lely
tactilely1443433tactilely
vilely1239443__vilely
virilely1444033virilely
vocally15188343vocal_ly
votively1744193votively

Search took 10 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.1731032896.0
2DLD Change Limit146162458.87316472.7
3Display Results45450.0162812.5
 (SQL Overall)178691459.06219718.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.