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

77 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
cingular1125698(None) 
cingula10327171cingula_
lingular9407501lingular
singular9327571singular
angular838542_angular
cannular1046292cannular
canular9310332can_ular
cingulate12238602cingulate
cingulum1342722cingulum
circular1247912circular
consular1038822consular
insular7138712_insular
ligular8348532li_gular
lingula8428802lingula_
lingulae9357032lingulae
pinnular1044432pinnular
singulars10305632singulars
ungular836782_ungular
acicular12218673aci_cular
annular737703_annular
binocular1394613binocular
biovular1343613biovular
canicular1346473canicular
cannula937443cannula_
cannulae1046503cannulae
cannulas1037593cannulas
canula8312973can_ula_
canulae9311193can_ulae
canulas9312863can_ulas
capsular1245413capsular
cellular1045173cellular
cigar8911803ci_g__ar
cinnabar1282553cinnabar
circulars1346543circulars
cislunar1082023cislunar
coagula1045413coagula_
condylar1443653condylar
copular113810613c_opular
cupular11317633c_upular
fibular12267983fi_bular
fistular1144253fistular
gular6314833___gular
ingulf10310353_ingul_f
ingulfs1134733_ingulfs
insulars8137323_insulars
jingler154311093jing_ler
jugular1534523_jugular
ligula7359673li_gula_
ligulae8308753li_gulae
ligulas8329173li_gulas
lingua7509913lingu_a_
linguae8398413lingu_ae
lingual8379083lingu_al
linguals9317223linguals
lingulate10368193lingulate
lunular736023lun_ular
mingler104213843ming_ler
pendular1144943pendular
piacular1246583piacular
pilular938203pi_lular
pinnula934923pinnula_
pinnulae1044183pinnulae
ranular739443ran_ular
regular838423_regular
simular938683si_mular
singularly1453233singularly
tegular836603_tegular
tingler83613343ting_ler
tissular843823tissular
titular737523ti_tular
triangular1162873triangular
undular837133_undular
ungula737603_ungula_
ungulae837313_ungulae
venular1037683ven_ular
vincula1246403vincula_
zonular1656493zon_ular

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.436409841.7
2DLD Change Limit146162777.86018595.7
3Display Results77770.0302566.7
 (SQL Overall)178691778.32621461.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.