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

122 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
absurds103500(None) 
absurd935901absurd_
abjures1636522abjures
abounds10217082abounds
absorbs1135612absorbs
absurder11134362absurder
absurdest12143912absurdest
absurdism14102542absurdism
absurdist12103922absurdist
absurdly1442902absurdly
assureds984492assureds
assures7611402assures
burds84626062_b_urds
surds65624662__surds
abasers95311973abaser_s
abduces1286243abduces
abducts1265313abducts
abfarads1443163abfarads
abhors11410623abhor_s
abjure1536743abjur_e
abjured1735083abjured
abjurer1634753abjurer
abjurers1733943abjurers
aboard9312613aboard_
aborts84916183ab_orts
abound9239863abound_
abris75722603ab__ris
abscess1133903abscess
absconds1343593absconds
abseils935973abseils
absents93510723absents
absorb1038013absor_b
abstruse1065513abstruse
absurdisms1592223absurdisms
absurdists13102643absurdists
absurdity1552213absurdity
absurdness1342893absurdness
abused95614273abused_
abusers94710553abusers
abuses85119103ab_uses
abuts75417073ab_u_ts
accords1247243accords
adjures1536233adjures
adsorbs1044713adsorbs
affords1435023affords
allures72913113allures
almuds9378773almu_ds
amours83512663amour_s
arbours93910043arbour_s
armures9510273armures
asserts74311793asserts
assorts73310153assorts
assumes967163assumes
assure6610773assur_e
assured858373assured
assurer767793assurer
assurers866313assurers
assuror754203assuror
assurors894043assurors
auburns935573auburns
augurs7399963augur_s
auras55932563a__uras
aures55137093a__ures
auris55331533a__uris
ausubos942943ausubos
awards107113453a_wards
axseeds1533393axseeds
azures15510183a_zures
bards87139643_b_ards
bastards113310313bastards
bauds85821043_bau_ds
bayards13379683bayards
beards94116673_beards
birds85421333_b_irds
blurbs10489313_blurbs
blurs74619083_blur_s
blurts84412643_blurts
boards94616933_boards
bounds94415803_bounds
bourgs9459993_bourgs
bourns84114063_bourns
buds75235173_b_u_ds
bunds85523543_b_unds
buras74736303_b_uras
burbs95423493_b_urbs
burd75534263_b_urd_
burgs84924093_b_urgs
burls74228853_b_urls
burns74926783_b_urns
burps94220173_b_urps
burrs74925653_b_urrs
burs65847423_b_ur_s
caesuras1055733caesuras
cesuras958693cesuras
curds85725613__curds
ensures73315903ensures
gabbards1445753gabbards
gourds8108253_gourds
hurds95219073__hurds
insureds9277613insureds
insures73117263insures
katsuras1243653katsuras
labours9349893labour_s
mansards1148013mansards
nurds65518523__nurds
obscures1245513obscures
obtunds1033763obtunds
rasures7312013rasures
sards64736183__sards
sords64527803__sords
sudds75513593__sudds
suds56135293__su_ds
suras55336333__suras
surd56433813__surd_
surfs85022543__surfs
tabards10310383tab_ards
tabours94110093tabour_s
tsuris62710203_tsuris
turds65021693__turds
urds55922433___urds
usurps8105073_usurps
visards11328153visards

Search took 8 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.403443402.0
2DLD Change Limit1340271226.55020462.1
3Display Results1221220.0462652.2
 (SQL Overall)1786911226.99925530.9
 
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.