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

198 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
desorbs1043771(None) 
desorb95210201desorb_
resorbs95010521resorbs
absorbs1135612absorbs
adsorbs1044712adsorbs
decors94017772decor_s
deforms1337802deforms
dehorns11428362dehorns
dehorts11379772dehorts
demobs11429482demo_bs
deports105012882deports
deserts82513052deserts
desires81316132desires
desorbed1236442desorbed
deworms1338032deworms
resorb84914352resorb_
resorts74817192resorts
sorbs75022102__sorbs
absorb1038013absorb_
adsorb946953adsorb_
assorts73310153assorts
bedsores1157633bedsores
besoms105712733beso_ms
besots86415453beso_ts
bevors111610343bevor_s
beworms1437933beworms
censors93611843censor_s
ceorls848163ce_orls
cesuras958693cesuras
darbs85323263d__arbs
deairs74013783deair_s
dears65736883de_ar_s
debarks14388493debarks
debars94218043debar_s
debones103315113debones
debris93311493de_bris
debs76530243de___bs
debtors1038533debtor_s
decares102818533decares
decerns10119053decerns
decocts1237833decocts
decodes113914983decodes
decor84717573decor__
decorous1138853decorous
decorum1246943decorum
decorums1344993decorums
decos85522123deco__s
decoys123911283deco_ys
deers64930523de_er_s
defers105116943defer_s
defoams1336193defoams
defocus1335283defocus
defogs1156683defo_gs
deforce13267243deforce
deforces14248403deforces
deforest1238793deforest
deform1259623defor_m
degerms1135623degerms
dehorn10439653dehor_n
dehort104618103dehor_t
dekares122710873dekares
demarks14339233demarks
demob104913503demo_b_
demons94917723demo_ns
demos86022993demo__s
demoses103815823demoses
demotes104717673demotes
demurs939773demur_s
denars74621433denar_s
denotes83817003denotes
deorbit1048173de_orbit
deorbits1144613de_orbits
departs104310683departs
deperms1236603deperms
deplores1139533deplores
depones103717093depones
deport94922393depor_t
deposes103117213deposes
depots94716343depo_ts
derby114715343de__rby
derms85022893de__rms
derris73615273de_rris
desalts839573desalts
desands94810163desands
describe1346243describe
describes1446003describes
descries11311923descries
descry1256183descr_y
desert72725493deser_t
deserve11108703deserve
deserves12109893deserves
desexes1537833desexes
designs9328313designs
desire7415303desir_e
desired9311983desired
desirer8310783desirer
desirers939263desirers
desirous947783desirous
desists83611723desists
desks105913073des__ks
desmans1039003desmans
desmids1166603desmids
desmoids1244973desmoids
desorbing1346363desorbing
desoxy1744623deso_xy
despoils1145623despoils
desponds1246243desponds
despots10319683despots
desserts9247923desserts
destroy1138153destroy
destroys1236693destroys
deters74724683deter_s
detours858043detours
detoxes1538803detoxes
devisors12347253devisor_s
devoirs1175783devoirs
devons104512253devo_ns
devotes113713753devotes
devours1166643devours
dewars105117073dewar_s
dewools1145593dewools
deworm1249533dewor_m
dhooras1135943dhooras
diestrus946523diestrus
disarms1039043disarms
discords1238593discords
disowns1136733disowns
disports111111113disports
disrobe1038993disrobe
disrobes1139743disrobes
distorts91112353distorts
disturbs1145403disturbs
dolors75115313dolor_s
donors75115793donor_s
doors65022133d_oor_s
dorks105724443d__orks
dorms85723843d__orms
dorps85419223d__orps
dorrs65520593d__orrs
dors56747603d__or_s
dosers75723633doser_s
escorts9418403_escorts
estrus61912113_estrus
exurbs1534423_exurbs
eyesores1145113eyesores
fedoras1137923fedoras
fetors91014473fetor_s
forbs105720803__forbs
herbs105520503he__rbs
kebobs14427293kebo_bs
kerbs115013673ke__rbs
lessors73610523lessor_s
mesons83215843meso_ns
nestors73614973nestor_s
oestrus7169583oestrus
orbs66626253___orbs
pelorus939273pelorus
pesos77221623peso__s
presorts105311683presorts
reabsorbs1342693reabsorbs
rebores95319163rebores
recombs1336753recombs
records105213923records
recorks134813023recorks
reforms1239823reforms
remoras9314073remoras
reports94916213reports
rescores105415693rescores
resoaks1148973resoaks
resods74116303reso_ds
resoles73823653resoles
resorbed1138533resorbed
resort65728623resor_t
resows93915353reso_ws
restores85222993restores
retorts76016513retorts
reverbs12368863reverbs
rewords115413983rewords
reworks145113603reworks
seisors73212843seisor_s
senoras72714953senoras
senores73218113senores
senors63620793senor_s
sensors73514643sensor_s
sobs64941753__so_bs
soras55041013__soras
sorb68333043__sorb_
sords64527803__sords
sores55454283__sores
sorns55028423__sorns
sorts54536663__sorts
sorus54527583__sorus
tenors63217753tenor_s
tensors72712373tensor_s
tsores65113663_tsores
tsoris63411193_tsoris
verbs104614393ve__rbs
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.390458182.1
2DLD Change Limit1340271986.26621389.6
3Display Results1981980.0762605.3
 (SQL Overall)1786911986.73226543.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.