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 “circular” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

93 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
circular124791(None) 
circulars1346541circulars
acicular12218672aci_cular
cingular11256982cingular
circler1136422circ_ler
circularly1754572circularly
circulate13810432circulate
circulator1446142circulator
furcular1345712furcular
piacular1246582piacular
acicula11228133aci_cula_
aciculae12267703aci_culae
aciculas12228563aci_culas
auricular1146323auricular
avicular13237283avicular
bilocular1363693bilocular
binocular1394613binocular
biovular1343613biovular
calycular1643493calycular
canicular1346473canicular
cannular1046293cannular
canular9310333c_anular
capsular1245413capsular
cartulary1444653cartulary
cellular1045173cellular
cicala10310063ci_cala_
cicalas1139303ci_calas
cingula10327173cingula_
circa9311403circ__a_
circle1039703circ_l_e
circled1237583circ_led
circlers1235353circ_lers
circles1139903circ_les
circlet11311473circ_let
circuit1148833circu_it
circuital1343853circuital
circuitry1652813circuitry
circuits1246023circuits
circuity1544973circuity
circularise15165993circularise
circularity1855573circularity
circularize24155403circularize
circulated1588063circulated
circulates1489283circulates
circulators1545733circulators
circulatory1854623circulatory
circumlunar1762393circumlunar
circumpolar1962073circumpolar
circus104310593circu__s
circuses1238253circuses
circusy14374593circu_sy
cislunar1082023cislunar
consular1038823consular
copular113810613c_opular
coruler9311713cor_uler
cupular11317633c_upular
curculio1243503curculio
curcuma1344773curcuma_
curcumas1454853curcumas
curricular14124163curricular
cuticular1345193cuticular
facular122810453_facular
fibular12267983fi_bular
fistular1144253fistular
furcula1245803furcula_
furculae1345073furculae
insular7138713_insular
jocular1637313_jocular
ligular8348533li_gular
lingular9407503lingular
locular938963_locular
macular113011953_macular
morular978223mor_ular
muscular1246253muscular
noncircular1552363noncircular
ocular8610143__ocular
opercular1345083opercular
oracular1047543oracular
oscular937943_oscular
pilular938203pi_lular
pinnular1044433pinnular
saccular1246903saccular
secular92211543_secular
simular938683si_mular
singular9327573singular
specular12217623specular
spicular12238913spicular
spiracular1453593spiracular
tissular843823tissular
titular737523ti_tular
utricular1145783utricular
vascular1346303vascular
vincula1246403vincula_

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 Limit146162937.64319123.6
3Display Results93930.0462021.7
 (SQL Overall)178691938.14221946.8
 
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.