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

62 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
dicotyl134440(None) 
dicotyls1444181dicotyls
dactyl1234982dac_tyl
diacetyl1452912diacetyl
dicot85429092dicot__
dicots94915792dicot_s
dicrotal1146822dicrotal
dicty115116292dic_ty_
epicotyl1543262epicotyl
acetyl11396553_acetyl
biacetyl1542473biacetyl
cacodyl1543213cacodyl
dacoity1366183dacoity_
dactyli1343603dac_tyli
dactyls1333913dac_tyls
decoy115716313deco_y_
decoys123911283deco_ys
diacetyls1542253diacetyls
diaconal1196133diaconal
dicey114819333dic_ey_
dichotic1647663dichotic
dickey165913523dickey_
dickeys17479303dickeys
dicky154816243dic_ky_
dicrotic1348883dicrotic
dicta84915633dic_t_a
dictum1136863dic_tum
dicycly1843273dicycly
didactyl1542183didactyl
digital937063digital
dimethyl1741913dimethyl
dimity12310473dimity_
diobol936883di_obol
diol57329133di_o__l
dipody1336363dipody_
dirty95617803di_rty_
distal73615773di_stal
distil73616433di_stil
ditty95019293di_tty_
divot95723073divot__
divots104712203divot_s
dotal64919623d__otal
doty86128223d__oty_
ductal938993duc_tal
edictal1046993edic_tal
epicotyls1642583epicotyls
lichtly15255523lichtly
licitly12276673licitly
nicety1138433nicety_
nicol71113293nico__l
nicotin948383nicotin
octyl10136063_oc_tyl
picot95031013picot__
picoted1239213picoted
picotee11311473picotee
picots104616443picot_s
pivotal1245433pivotal
protyl11308213_protyl
ricotta955433ricotta
rictal83113183ric_tal
trotyl9236673_trotyl
wicopy1634033wicopy_

Search took 7 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.390458182.1
2DLD Change Limit134027625.92322628.2
3Display Results62620.0134769.2
 (SQL Overall)178691626.32628247.1
 
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.