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 “doublets” 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
doublets1125736(None) 
doublers11288501doublers
doubles103113351double_s
doublet103914031doublet_
bomblets1436022bomblets
couplets12389872couplets
double94013992double__
doubled11289952double_d
doubler103110082double_r
doubleton1252842doubleton
doubletons1352872doubletons
doubters11257392doubters
doubtless1243312doubtless
doubts968732doub__ts
driblets11266092driblets
goblets103210182go_blets
outlets73616362_outlets
roubles93413512rouble_s
sublets92616702_sublets
amulets939923amu_lets
auklets11298573_auklets
baubles113611863bauble_s
blets75324943___blets
bobbles104514913bobble_s
bomblet13412263bomblet_
booklets14247123booklets
boomlets12246673boomlets
boucles113113003boucle_s
boules84925973bou_le_s
boulles93114123boulle_s
bouquets19244523bouquets
bulblets1255353bulblets
bullets93516393_bullets
cablets114216343_cablets
cloudlets1242823cloudlets
cobblers14359593cobblers
cobbles133814823cobble_s
cobles104622883co_ble_s
collets93517903co_llets
corslets1038273corslets
coulees9315513cou_lees
couplers123311323couplers
couples115317053couple_s
couplet114717943couplet_
culets85518513_cu_lets
cullets94015613_cullets
cutlets94113653_cutlets
dabblers13379363dabblers
dabbles124514773dabble_s
daubers104610423daub_ers
daubes94913703daub_e_s
daubiest1138233daubiest
dibblers13377583dibblers
dibbles124013333dibble_s
doable93115243doable__
dobbers123513253do_bbers
dobbies124113063dobbie_s
dobies94422093do_bie_s
doblas93812293do_bl_as
doblons1037043do_blons
dockets144412243do_ckets
doglegs1034783do_glegs
dogsleds1142913dogsleds
doles67843753do__le_s
dolts65626313do__l_ts
dongles93212873dongle_s
doobies103915673doobie_s
doodlers10338843doodlers
doodles93614163doodle_s
doolees83711613do_olees
doorless936713doorless
dottles83912283dottle_s
doubleness1345783doubleness
doubling1238153doubling
doubloon1143273doubloon
doubloons1242823doubloons
doublure1142593doublure
doublures1242573doublures
doubly12328963doubl__y
doubt8720093doub__t_
doubted11307483doubte_d
doubter10298353doubte_r
douches134315233douche_s
doulas75114993dou_l_as
dourest8312943dou_rest
dourness947683dourness
dousers84817273dou_sers
douses74928933dou_se_s
downless1236363downless
doyleys14384923do_yleys
drabbets13294823drabbets
dribblets14294143dribblets
driblet103712243driblet_
droplets1136063droplets
drubbers13386033drubbers
druggets11313913druggets
drumbles13277723drumble_s
drupelets1242683drupelets
dubbers124011823d_ubbers
dubiety1344593d_ubiety
duelers83412053d_uelers
duets65323883d_u__ets
dulcets1046283d_ulcets
dullest8312633d_ullest
duvets1039223d_u_vets
foibles1238853foible_s
foulest10313313fou_lest
giblets103210423_giblets
gobbets12327643go_bbets
gobblers13308343gobblers
gobbles123512583gobble_s
goblet93219483go_blet_
goglets9379783go_glets
gourmets1144153gourmets
guglets9369693_guglets
gullets84013713_gullets
hobblers15308513hobblers
hobbles143313783hobble_s
hooklets15217203hooklets
howlets13329223ho_wlets
jobless16237563jo_bless
joules134116823jou_le_s
lobules92510813lobule_s
moonlets10247473moonlets
moults84713703mou_l_ts
mullets93614783_mullets
nobblers12318563nobblers
nobbles114014523nobble_s
nobles83319723no_ble_s
noblest93613563no_blest
nombles113212343nomble_s
nounless837253nounless
nutlets74111253_nutlets
objets15125323_o_bjets
omelets938333_omelets
orbless937493_orbless
outbleats1144393_outbleats
outbless1037963_outbless
outlet63728683_outlet_
outsets73514923_outsets
owlets93110393_o_wlets
poults84613483pou_l_ts
pullets94015163_pullets
redoublers1342413redoublers
redoubles1244263redouble_s
riblets93412553_riblets
robles85321693ro_ble_s
rootlets8308653rootlets
rouble83913313rouble__
roundlets10175293roundlets
rubles83921703_ruble_s
runlets73310773_runlets
solubles1065893soluble_s
sorbets93012513sorb_ets
soulless8218763soulless
soupless10268463soupless
sublet82827243_sublet_
sublots92410913_sublots
subnets92512083_subnets
subsets92813103_subsets
tablets94714383_tablets
toilets74112913to_ilets
tombless1236783tombless
tonlets73212503to_nlets
tousles74113933tousle_s
touzles16359223touzle_s
townlets1134773townlets
troublers1135003troublers
troubles1057203trouble_s
undoubles1243923undouble_s
wobblers15327883wobblers
wobbles143412433wobble_s

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.406440125.6
2DLD Change Limit1461621727.14020470.9
3Display Results1721720.0632730.2
 (SQL Overall)1786911727.60923484.2
 
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.