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 “circlets” 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
circlets123566(None) 
circlers1235351circlers
circles1139901circle_s
circlet11311471circlet_
circle1039702circle__
circled1237582circle_d
circler1136422circle_r
circuits1246022circuits
corslets1038272corslets
crickets16418122crickets
aiglets84012913ai_glets
aircrews13122813aircrews
airless73712043air_less
armlets94610063_armlets
billets94516153bi_llets
birches143412323birche_s
birlers93813003bir_lers
birles84920643bir_le_s
cablets114216343c_ablets
cachets145014263c_achets
callets93821703c_allets
camlets114314623c_amlets
capelets1268603capelets
caplets114914523c_aplets
carcanets1347313carcanets
carcels114516063carc_els
careless102813633careless
carets85330773car__ets
carles85435083car_le_s
carless95118493car_less
carnets93918403car_nets
carolers103314173carolers
carpets113915333car_pets
cermets1139713cer_mets
chalets122813473c_halets
chaplets1556883chaplets
chicles143512503chicle_s
cigarets1145473cigarets
cinches144215773cinche_s
circling1338423circling
circuit1148833circuit_
circuity1544973circuity
circulars1346543circulars
circulate13810433circulate
circulates1489283circulates
circus104310593circ__us
circuses1238253circuses
cires74932913cir__e_s
cirques1836463cirque_s
ciscoes113610733ciscoe_s
citoles9312553citole_s
civets115212543ci__vets
collets93517903c_ollets
coracles121811163coracle_s
cordless11299963cordless
coreless103013833coreless
cornets94820573cor_nets
coronets103814363coronets
corselets1147313corselets
corsets94819803cor_sets
corslet9318063corslet_
corulers1039773corulers
corvets124715023cor_vets
couplets12389873couplets
cricket154716953cricket_
crochets15359833crochets
crockets16339543crockets
cruets85314953c_r_uets
crusets93811043c_rusets
culets85518513c__ulets
cullets94015613c_ullets
curches143512743curche_s
curdlers11368493curdlers
curdles103814573curdle_s
cureless10319703cureless
curets84922343cur__ets
curlers94218073cur_lers
curlews12387393cur_lews
curvets12399913cur_vets
cutlets94113653c_utlets
cyclers1435873c_yclers
cycles1339303c_ycle_s
driblets11266093driblets
encircles1343923encircle_s
filets94718953fi__lets
fillets103414753fi_llets
fireless112810593fireless
fitchets16307413fitchets
giblets103210423gi_blets
giglets93211553gi_glets
gimlets10338433gi_mlets
girdlers10195403girdlers
girdles92210003girdle_s
gurglets10355543gurglets
harslets1137833harslets
hirples12149643hirple_s
hirsles101510073hirsle_s
icicles1135943icicle_s
inlets63915573_i_nlets
ireless72312243_ireless
islets64513083_i_slets
kinglets13318583kinglets
kirtles11309663kirtle_s
martlets103310483martlets
millets94216843mi_llets
miracles1238333miracle_s
partlets102811523partlets
pickets154314183pi_ckets
piglets103311793pi_glets
piolets93513193pi_olets
prickets16329083prickets
recircles1344433recircle_s
relets64025673__relets
riblets93412553ri_blets
rickets134915093ri_ckets
rillets74216153ri_llets
ringlets92910243ringlets
ripplets12316733ripplets
rivulets1174753rivulets
scarlets10178573scar_lets
singlets93611473singlets
tartlets8289663tartlets
tercelets1144813tercelets
tercets93512443terc_ets
tickets134113683ti_ckets
tireless82510263tireless
triolets83410143triolets
triplets103510263triplets
varlets10411573var_lets
violets102210003vi_olets
wickets164010943wi_ckets
wiglets113411423wi_glets
willets104414323wi_llets
winglets12299593winglets
wireless11249633wireless

Search took 9 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.453394461.4
2DLD Change Limit1461621357.61019206.6
3Display Results1351350.0462934.8
 (SQL Overall)1786911358.10922036.1
 
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.