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

172 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
absurd93590(None) 
absurds1035001absurds
abjure1536742abjure
abjured1735082abjured
aboard9312612aboard
abound9239862abound
absorb1038012absorb
absurder11134362absurder
absurdly1442902absurdly
abused95614272abused
assure6610772assure
assured858372assured
burd75534262_b_urd
surd56433812__surd
abased96514993abased
abaser86414343abaser_
abasers95311973abasers
abashed1357663abashed
abated95918453abated
abduce1197193abduce
abduced1374843abduced
abduct11108543abduct
abed79734133ab__ed
abfarad1344223abfarad
abhor10411063abhor_
abhors11410623abhors
abided105313313abided
abjurer1634753abjurer
abjures1636523abjures
abled86926833ab_led
abler75624313abler_
ablush1147223ablush
abluted10188363abluted
aboded104912513aboded
abort76133583ab_ort
abounds10217083abounds
about75229083abou_t
abri65522213ab__ri
abroad9310943abroad
abrupt1039943abrupt
abs59356073abs___
abscond1244503abscond
abseil837183abseil
absent84016993absent
absorbed1344263absorbed
absorbs1135613absorbs
absurdest12143913absurdest
absurdism14102543absurdism
absurdist12103923absurdist
absurdity1552213absurdity
abuse77119563ab_use
abuser85413683abuser
abusers94710553abusers
abuses85119103abuses
abut66834953ab_u_t
abuts75417073ab_uts
abuzz15517213ab_uzz
accord1178843accord
adjure1435843adjure
adjured1634883adjured
adsorb946953adsorb
afeard1058263afeard
afford1346493afford
aisled74516183aisled
allure63012943allure
allured8299173allured
almud84012183almu_d
aloud65018073alou_d
amour75014853amour_
amours83512663amours
amused94412513amused
arbour84211333arbour_
arboured1156253arboured
arbours93910043arbours
argued84311173argued
armure8710133armure
around72712413around
ashed97829773a_shed
asked106919313a_sked
assert64922583assert
assort64916383assort
assume897563assume
assumed1065293assumed
assureds984493assureds
assurer767793assurer
assures7611403assures
assuror754203assuror
auburn836213auburn
augur64311213augur_
augured987193augured
augurs7399963augurs
augury10366663augury
auld54125363a__uld
aura45836253a__ura
ausubo853653ausubo
award97118043a_ward
axseed1456993axseed
azure14911483a_zure
bard75648863_b_ard
based85331583bas_ed
baser74828923baser_
bashed126225703bashed
basked135218603basked
bastard103012423bastard
basted95227233basted
baud74928423_bau_d
bayard124411663bayard
beard86024963_beard
bird76128323_b_ird
blued84520323_blued
blur66020533_blur_
blurb95214903_blurb
blurs74619083_blurs
blurt77625623_blurt
board85523003_board
bound84819583_bound
bourg84113843_bourg
bourn75518483_bourn
bud67041273_b_u_d
bund75530663_b_und
bur55744693_b_ur_
bura66139533_b_ura
burb85334673_b_urb
burds84626063_b_urds
burg74930363_b_urg
burl64937183_b_url
burn65636423_b_urn
burp85028883_b_urp
burr65631233_b_urr
burs65847423_b_urs
bury95633593_b_ury
bused85624493_bused
caesura956233caesura
cesura838763cesura
curd77634983__curd
ensued73610483ensued
ensure63416003ensure
ensured83512943ensured
gabbard1336553gabbard
gourd71011903_gourd
insure63416603insure
insured83714253insured
issued746723issued
katsura1143753katsura
labour84210933labour_
laboured1156323laboured
labours9349893labours
mansard1049313mansard
nurd56224343__nurd
obscure1145333obscure
obscured1343893obscured
obtund945583obtund
rasure6311423rasure
sard55344243__sard
sord56237203__sord
sudd64719773__sudd
sued56537933__sued
sura45740293__sura
surds65624663__surds
sure45447413__sure
surf76039313__surf
tabard9313333tab_ard
tabour84011323tabour_
taboured1156273taboured
tabours94110093tabours
tabued94310403tab_ued
turd56027623__turd
unsure62815413unsure
urd46427043___urd
usurp7106903_usurp
usury887623_usury
visard103910123visard

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.1431249587.4
2DLD Change Limit1127161725.56320261.7
3Display Results1721720.0434000.0
 (SQL Overall)1786911725.74931082.1
 
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.