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

76 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
absorbed134425(None) 
absorber1254301absorber
adsorbed1243431adsorbed
abhorred1443492abhorred
aborted10310422ab_orted
absolved1443132absolved
absorb1038002absorb__
absorbent1345022absorbent
absorbers1353972absorbers
absorbs1135602absorb_s
adsorber1143492adsorber
assorted956592assorted
desorbed1236432desorbed
reabsorbed1542582reabsorbed
resorbed1138522resorbed
sorbed94916512__sorbed
unabsorbed1542362unabsorbed
abhorrer1343383abhorrer
abjured1735073abjur_ed
aboded104912513ab_o_ded
aborter939923ab_orter
abscised1364133abscised
absconded1543003absconded
abseiled1144733abseiled
absented1156613absented
absolve1244513absolve_
absolver1343683absolver
absolves1344413absolves
absorbant1345073absorbant
absorbency1962413absorbency
absorbents1443423absorbents
absorbing1444473absorbing
absterged1353353absterged
absurd935903absur__d
absurder11134353absurder
accorded14155343accorded
acorned10238263a_corned
adored84714233a_dor_ed
adorned9256883a_dorned
adsorb946943adsorb__
adsorbent1243873adsorbent
adsorbers1243253adsorbers
adsorbs1044703adsorb_s
afforded1643433afforded
arbored103811603arbor_ed
armored102610473armor_ed
ascribed1374693a_scribed
asserted957903asserted
assoiled935013assoiled
assorter866663assorter
assured858373assur_ed
attorned955353attorned
ausformed1542323ausformed
barbed115121313_b_arbed
berobed1238233_berobed
blobbed11366563_blobbed
blurbed12337613_blurbed
bobbed104315833_b_obbed
bombed134113873_b_ombed
boobed114514873_b_oobed
bored85034303_b_or_ed
borked135117293_b_orked
disrobed1238093disrobed
labored102810243lab_or_ed
observed1444373observed
orbed85516193___orbed
preabsorbed1851983preabsorbed
resorted9313493resorted
sobbed113516263__sobbed
sorbet83924073__sorbet
sored66141783__sor_ed
sorned74820043__sorned
sorted74523713__sorted
tabored102810563tab_or_ed
unsorted9312513unsorted
visored1138143visor_ed

Search took 9 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.1701051123.5
2DLD Change Limit146162768.59617003.5
3Display Results76760.0302533.3
 (SQL Overall)178691768.79620315.0
 
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.