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

135 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
abluent93962(None) 
abluents1045471abluents
abducent13105702abducent
ablest84721832abl_est
absent84016992ab_sent
affluent1494562affluent
ailment9314232ailment
blent76230952_bl_ent
bluest84016482_bluest
bluet75631192_blue_t
blunt75525022_blu_nt
diluent8310262diluent
eluent6315482_eluent
fluent9313932_fluent
abducens1393483abducens
abduct11108543abdu_ct
abet610547943ab__e_t
abetment1248233abetment
abeyant1248083abeyant
abject17137703ab_ject
ablaut8313263abl_aut
able66340533abl_e__
abled86926833abl_e_d
ableist9311773ableist
abler75624313abl_e_r
ables75935543abl_e_s
ablins8316193abl_ins
ablush1147223ablu_sh
abluted10188363abluted
abought1346153abought
abound9239863abou_nd
about75229083abou__t
abrupt1039943abru_pt
absents93510723ab_sents
absolvent1454103absolvent
abut66834953ab_u__t
abutment1247223abutment
accent105116263a_ccent
acquest1837173acquest
adducent1284713adducent
advent102613753a_dvent
affluents15133313affluents
agent65829643a__gent
aglet65534143agl_e_t
ailments1039443ailments
alant55742293a_l_ant
albeit8314343a_lbeit
albumen1135243albumen_
albumens1244143albumens
alert54740653a_l_ert
alien56425583a_lien_
aliens65619213a_liens
aliment9316703aliment
alkene104114003a_lkene
alumna857343a_lumna
alumni856753a_lumni
ambient11310093ambient
ambulant1247163ambulant
ament76036543a__ment
amount8414483amou_nt
amulet8419573amule_t
ancient9514733ancient
anent54931843a__nent
aplenty1237173apl_enty
ardent73022613a_rdent
argent74023663a_rgent
argument1158903argument
arpent84822093a_rpent
ascent84519653a_scent
aslant6317753asl_ant
asquint16208323asquint
assent65119953a_ssent
attent62818323a_ttent
audient8312303audient
augment10910203augment
auldest839893auldest
aunt46553653a__u_nt
avaunt959603avau_nt
baguet9316103bague_t
bailment1249183bailment
baldest102313533baldest
baleen8613053baleen_
baleens938473baleens
ballet84733973balle_t
bent67759913_b__ent
bleat75737003_bl_eat
blend85317453_bl_end
blest76431723_bl_est
blet66247673_bl_e_t
blue65328463_blue__
blued84520323_blue_d
blueing103710203_blueing
bluely113310083_bluely
bluer74918493_blue_r
blues75127043_blue_s
bluesy11448983_bluesy
bluets87215493_bluets
bluey104817053_blue_y
blueys11419523_blueys
bluing94914483_bluing
blunts84512893_blu_nts
blurt77625623_blu_rt
brent75734133_b_rent
brunet84419293_brunet
brunt75728753_bru_nt
bunt65850853_b_u_nt
burnt75230333_b_urnt
cablet104429463cabl_e_t
client8316343_client
diluents946063diluents
effluent14134413effluent
eluant6315093_eluant
eluents738703_eluents
fulgent1138903fulgent
influent1147633influent
lent46360533__l_ent
lucent8313823__lucent
lunet56835423__lunet
lunt46148843__lu_nt
opulent938833opulent
patulent1048603patulent
reblent9614253rebl_ent
refluent1147443refluent
relent64431853rel_ent
relucent1049283relucent
salient7419763salient
sequent16410323sequent
silent64125843sil_ent
sklent103614353skl_ent
solvent10310833solvent
splent84720193spl_ent
tablet84227643tabl_e_t
talent6323323tal_ent
toluene736463toluene
unguent839123unguent

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.420425454.8
2DLD Change Limit1340271357.36018210.2
3Display Results1351350.0502700.0
 (SQL Overall)1786911357.83022821.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.