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

97 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
adsorbs104471(None) 
absorbs1135611absorbs
adsorb946951adsorb_
absorb1038012absorb_
adores74420722ad_ores
adorns74212612ad_orns
adsorbed1243442adsorbed
adsorber1143502adsorber
adsorbers1243262adsorbers
adverbs13254272adverbs
assorts73310152assorts
desorbs10437712desorbs
resorbs95010522resorbs
sorbs75022102__sorbs
abhors11410623abhor_s
aborts84916183a_borts
absorbed1344263absorbed
absorber1254313absorber
absorbers1353983absorbers
absurds1035003absurds
accords1247243accords
acorns85013013a_corns
actors81016773actor_s
adders84315703adder_s
adheres11310163adheres
adios65822863adio__s
adjoins1585983adjoins
adjourns1662863adjourns
adjures1536233adjures
admires1038663admires
adnouns835453adnouns
adobe84814713ad_o_be
adobes94411533ad_obes
adobo84711593ad_o_bo
adobos9438453ad_obos
adonis7314063ad_onis
adopts998083ad_opts
adore65723673ad_or_e
adored84714243ad_ored
adorer74713453ad_orer
adorers84411733ad_orers
adorn64917093ad_or_n
ados57633513ad_o__s
adsorbate1243183adsorbate
adsorbates1342833adsorbates
adsorbent1243883adsorbent
adsorbents1352833adsorbents
adsorbing1344123adsorbing
adverb12265413adverb_
adverts11308513adverts
advisors12143903advisor_s
affords1435023affords
agoras7613343a_goras
algors7312553algor_s
allsorts844923allsorts
angoras8811363angoras
aplombs1343263aplombs
arbores94016033arbores
arbors84717883arbor_s
arbs66834733a___rbs
ardors74416873ardor_s
armors85017813armor_s
arsons63917213arso_ns
asserts74311793asserts
assoils776663assoils
assort64916383assor_t
assures7611403assures
attorns738443attorns
auroras7311703auroras
ausforms1343933ausforms
bedsores1157633bedsores
darbs85323263_d_arbs
desorb95210203desorb_
doors65022133_door_s
dorks105724443_d_orks
dorms85723843_d_orms
dorps85419223_d_orps
dorrs65520593_d_orrs
dors56747603_d_or_s
forbs105720803__forbs
madworts1456173madworts
odors64514283od_or_s
orbs66626253___orbs
reabsorbs1342693reabsorbs
resorb84914353resorb_
resorts74817193resorts
sobs64941753__so_bs
soras55041013__soras
sorb68333043__sorb_
sords64527803__sords
sores55454283__sores
sorns55028423__sorns
sorts54536663__sorts
sorus54527583__sorus
tsores65113663_tsores
tsoris63411193_tsoris
visors92912223visor_s

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.453394461.4
2DLD Change Limit134027976.01622278.4
3Display Results97970.0303233.3
 (SQL Overall)178691976.49927495.2
 
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.