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

130 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
absorb103801(None) 
absorbs1135611absorbs
adsorb946951adsorb
abhor10411062abhor_
abhors11410622abhors
abort76133582ab_ort
absorbed1344262absorbed
absorber1254312absorber
absurd935902absurd
adsorbs1044712adsorbs
assort64916382assort
desorb95210202desorb
reabsorb1243352reabsorb
resorb84914352resorb
sorb68333042__sorb
abaser86414343abaser_
abasers95311973abasers
abator84512723abator_
abators94413093abators
abbot9318453abbo_t
abbots1039283abbots
abjure1536743abjure
abler75624313abler_
abloom1039783abloom
abo59045963ab_o__
aboard9312613aboard
abode85518813ab_ode
abohm1247973ab_ohm
aboil72217543ab_oil
aboma91114603ab_oma
aboon74918703ab_oon
aboral8314373ab_oral
aborts84916183ab_orts
abos67734413ab_o_s
about75229083ab_out
above105414323ab_ove
abri65522213ab__ri
abroad9310943abroad
abs59356073abs___
abscond1244503abscond
abseil837183abseil
absent84016993absent
absolve1244513absolve
absorbant1345083absorbant
absorbent1345033absorbent
absorbers1353983absorbers
absorbing1444483absorbing
absurds1035003absurds
abuser85413683abuser_
abusers94710553abusers
abvolt11169833abvolt
accord1178843accord
acerb9312763a_cerb
acorn75616623a_corn
actor71116083actor_
actors81016773actors
adore65723673a_dore
adorn64917093a_dorn
adsorbed1243443adsorbed
adsorber1143503adsorber
adverb12265413adverb
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
barb85240063_b_arb
baser74828923baser_
blob86027093_blo_b
blurb95214903_blurb
bob76755673_b_o_b
bomb106927423_b_omb
boob85932583_b_oob
boor66130683_boor_
boors74325013_boors
bora66141633_b_ora
bore66051333_b_ore
bork106933823_b_ork
born67338413_b_orn
bort65960963_b_ort
burb85334673_b_urb
cabob114616813cab_o_b
desorbs10437713desorbs
forb97131333__forb
haboob1377883hab_oob
kabob134113933kab_o_b
labor75117313lab_or_
labors84016413lab_ors
nabob93913743nab_o_b
orb55736863___orb
preabsorb1542853preabsorb
rasbora945943rasbora
reabsorbs1342693reabsorbs
resorbs95010523resorbs
resort65728623resort
sob57857943__so_b
sora45746913__sora
sorbs75022103__sorbs
sord56237203__sord
sore47059533__sore
sori46039843__sori
sorn46641063__sorn
sort46264813__sort
tabor75518393tab_or_
tabors84517113tab_ors
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.376475242.0
2DLD Change Limit1127161304.76323664.9
3Display Results1301300.0502600.0
 (SQL Overall)1786911305.18934436.5
 
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.