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 “bascules” 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
bascules123668(None) 
bascule1136571bascule_
barbules1238042barbules
basques18248672basqu_es
bastiles10313352bastiles
macules114015132ma_cules
oscules938122_oscules
saccules1237032saccules
abacuses1235763abacuses
abscises1246233abscises
accuses114112193_accuses
aculei839793_a_culei
aculeus937513_a_culeus
acutes83917723_a_cutes
ampules1189433_ampules
arcuses94814693_arcuses
asceses938623_asceses
ascites9312603_ascites
ascus75013583_ascu__s
assumes967163_assumes
assures7611403_assures
babbles104416323ba_bbles
babuls105413643ba_bul_s
baches135426943ba_c_hes
backless162910633ba_ckless
bacula103112673ba_cul_a
baculum1345703ba_culum
baculums1443723ba_culums
baffles153710683ba_ffles
bagfuls1334753bagful_s
bales76250083ba___les
ballutes1037523ballutes
bangles103617413ba_ngles
barbule1137943barbule_
barques18259643barqu_es
basaltes10367683basaltes
basalts9358963bas_alts
baseless1099563bas_eless
bases75644353bas___es
bashes115631393bas__hes
basifies13310493basifies
basils85717473bas_il_s
basque17259083basqu_e_
basses85428303bas__ses
bastes85330383bas__tes
bastile9313913bastile_
bastilles1147353bastilles
batches144019613batc_hes
battles94517683ba_ttles
battues94610193battu_es
baubles113611863ba_ubles
baulks12429373ba__ulks
besmiles1237393besmiles
biscuits1245133biscuits
bisques18236893bisqu_es
blastulas1143593blastulas
boscages1366643boscages
bosques18217973bosqu_es
boucles113113003bouc_les
boules84925973b__oules
brickles162810283brickles
bricoles122610303bricoles
buckles153416093b_uckles
bustles93816323bus_tles
byssuses1342273byssuses
cackles153717203ca_ckles
calculus1255333calculus
capsules1236623capsules
cascables15165773cascables
cascades13128553cascades
casques18278983casqu_es
castles94917733cas_tles
caucuses1236783caucuses
caules85927253ca__ules
cuscuses1235863cuscuses
dasyures1254153dasyures
discuses113112863discuses
fasces114914543fasc__es
fascicles1664263fascicles
fascicules1742983fascicules
fascines13310143fascines
fescues1236783fescu_es
hackles162917063ha_ckles
hassles103411693has_sles
hercules1337633hercules
insculps1243393insculps
jacales16310323ja_cales
lacunes9159623la_cunes
locules92812603_locules
mackles154415753ma_ckles
macles107023223ma_c_les
maculas113114023ma_culas
macule104115273ma_cule_
maculed123510053ma_culed
majuscules2151553majuscules
masculines1445513masculines
masques18239363masqu_es
masscults13103013masscults
miscues11312393miscu_es
misrules1039383misrules
muscles11310563musc_les
obscures1245513obscures
opuscules1342753opuscules
oscule838193_oscule_
papules112411573pa_pules
pascals11610013pascal_s
passuses1036773passuses
pastures10311963pastures
pustules1038443pustules
rascals959663rascal_s
rassles73513923ras_sles
rasures7312013ras_ures
rescales103414573rescales
rescues9312753rescu_es
saccule1136743saccule_
sacculus1244813sacculus
scales84529313__scales
sculks123610263__sculks
sculls84613883__sculls
sculps104611753__sculps
scutes85219193__scutes
spicules12219803spicules
tackles133816523ta_ckles
upscales12155993upscales
vacuoles1345013va_cuoles
valvules1443473valvules
vascula1245853vascul_a
vascular1346293vascular
vasculum1542983vasculum
vasculums1642143vasculums

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 Filter1786911461620.470380193.6
2DLD Change Limit1461621307.15620425.1
3Display Results1301300.0462826.1
 (SQL Overall)1786911307.67223291.3
 
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.