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

55 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
duodena94345(None) 
duodenal1042561duodenal
duodenum1242252duodenum
bodega1034933_bodega
burden9412473burden_
burdens1039713burdens
codeia94112193_codeia
codeina104010323_codeina
coden86128543_coden_
codens94821013_codens
deaden83714323deaden_
deadens93410693deadens
deodand1035713deodand
deodara945243deodara
diode74716113diode__
diodes83915783diode_s
docent92918683d_ocent
dona55529633d_o__na
donna66215033d_o_nna
doven94718553d_oven_
dovens104413903d_ovens
doyen95014413d_oyen_
doyens104810223d_oyens
dozen155017473d_ozen_
dozens164612463d_ozens
dracena1034923dracena
drosera836203drosera
dude65629663du_de__
duded84417133du_de_d
dudeen857173du_deen
dudeens934863dudeens
dudes75424373du_de_s
duding93913323du_ding
duenna734593du_enna
duodenums1351463duodenums
duotone836893duotone
elodea738673elode_a
erodent8313823erodent
euglena843953euglena
gulden8328763gulden_
guldens9356573guldens
loden66621143_loden_
lodens74315063_lodens
louden73711793louden_
loudens8368053loudens
noumena945633noumena
novena936763_novena
odea56224573__ode_a
pudenda1142963pu_denda
rodent7519243_rodent
subdean1037403subdean
subpena1136673subpena
sudden83310833sudden_
suddens9308783suddens
wooden103610303wooden_

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.436409841.7
2DLD Change Limit134027557.00319138.5
3Display Results55550.0301833.3
 (SQL Overall)178691557.46923924.4
 
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.