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 “adsorb” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

114 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
adsorb94695(None) 
absorb1038011absorb
adsorbs1044711adsorbs
absorbs1135612absorbs
adore65723672ad_ore
adorn64917092ad_orn
adsorbed1243442adsorbed
adsorber1143502adsorber
adverb12265412adverb
assort64916382assort
desorb95210202desorb
resorb84914352resorb
sorb68333042__sorb
abhor10411063abhor_
abhors11410623abhors
abort76133583a_bort
absorbed1344263absorbed
absorber1254313absorber
absurd935903absurd
accord1178843accord
acerb9312763a_cerb
acorn75616623a_corn
actor71116073actor_
actors81016763actors
adder75419593adder_
adders84315703adders
adhere10310333adhere
adios65822863adio_s
adjoin14107293adjoin
adjourn1563433adjourn
adjure1435843adjure
admire949933admire
adnoun757033adnoun
ado49146873ad_o__
adobe84814713ad_obe
adobo84711593ad_obo
adopt81219743ad_opt
adored84714243ad_ored
adorer74713453ad_orer
adores74420723ad_ores
adorns74212613ad_orns
ados57633513ad_o_s
adown95611663ad_own
adoze155713833ad_oze
adroit7518793adroit
ads49755733ads___
adsorbate1243183adsorbate
adsorbent1243883adsorbent
adsorbers1243263adsorbers
adsorbing1344123adsorbing
adverbs13254273adverbs
advert103215783advert
advisor11134163advisor_
advisors12143903advisors
advisory15132943advisory
afford1346493afford
afore85818603a_fore
agora6914333a_gora
algor6513053algor_
algors7312553algors
also46423443also__
amort75832203a_mort
angora71111573angora
aplomb1236203aplomb
aport75432173a_port
arb510448423a___rb
arbor74818113arbor_
arbors84717883arbors
ardor64617863ardor_
ardors74416873ardors
armor75118053armor_
armors85017813armors
armory114211473armory
arson55118833arso_n
arsons63917213arsons
ashore9414613ashore
assert64922583assert
assoil688543assoil
assorts73310153assorts
assure6610773assure
attorn6310793attorn
aurora6411763aurora
ausform1245233ausform
bedsore1057803bedsore
darb76033533_d_arb
desorbs10437713desorbs
door56928513_door_
doors65022133_doors
dor47253923_d_or_
dore56353303_d_ore
dork96531463_d_ork
dorm76834633_d_orm
dorp76028053_d_orp
dorr56627723_d_orr
dors56747603_d_ors
dory85836233_d_ory
forb97131333__forb
madwort13611363madwort
odor55718093od_or_
odors64514283od_ors
orb55736863___orb
reabsorb1243353reabsorb
resorbs95010523resorbs
resort65728623resort
sob57857943__so_b
sora45746913__sora
sorbs75022103__sorbs
sord56237203__sord
sore47059533__sore
sori46039843__sori
sorn46641063__sorn
sort46264813__sort
visor82512833visor_
visors92912223visors

Search took 6 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 Filter1786911127160.390458182.1
2DLD Change Limit1127161145.48320557.4
3Display Results1141140.0333454.5
 (SQL Overall)1786911145.90630255.8
 
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.