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

43 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
adducent128471(None) 
abducent13105701abducent
abducens1393482abducens
adduce1076452adduce__
adduced1274352adduce_d
adducer1184162adduce_r
adducers1283442adducers
adduces1185762adduce_s
adducing1384112adducing
adduct1087372adduc__t
adjacent18134312adjacent
abduce1197193abduce__
abduced1374843abduce_d
abducentes1552083abducentes
abduces1286243abduce_s
abducing1474063abducing
abduct11108543abduc__t
abluent939623ablu_ent
accent105116263a__ccent
acescent1248013acescent
acidulent1243653acidulent
addend9458453add__end
addict10711203addic__t
addrest958633add_rest
adducted1343913adducted
adducting1494303adducting
adductor1243463adductor
adducts1174603adduc_ts
adherent1247783adherent
adjutant1664463adjutant
adjuvant1983033adjuvant
advent102613753a_d_vent
ardent73022613ard__ent
argument1158903argument
ascent84519653a__scent
audient8312303aud_ient
decent94023703__decent
descent102616293_descent
docent92918683__docent
indecent11411273indecent
lucent8313823__lucent
oddment1145923odd_ment
relucent1049283relucent

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.1561145455.1
2DLD Change Limit146162437.20320291.8
3Display Results43430.0162687.5
 (SQL Overall)178691437.37524229.3
 
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.