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

105 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
consular103882(None) 
cannular1046292cannular
canular9310332can_ular
capsular1245412capsular
cingular11256982cingular
condylar1443652condylar
consoler102812612consoler
consul82312302consul__
consulate11612232consulate
consuls92412322consul_s
consult92513632consul_t
consulter1198222consulter
consultor1176472consultor
consults10219982consults
consumer1238502consumer
copular113810612co_pular
insular7138712_insular
nonsolar847082nonsolar
nonsugar944362nonsugar
tonsilar843952tonsilar
zonular1656492zon_ular
angular838543_angular
annular737703_annular
anovular1144163anovular
canicular1346473canicular
cannula937443cannula_
cannulae1046503cannulae
cannulas1037593cannulas
canula8312973can_ula_
canulae9311193can_ulae
canulas9312863can_ulas
cellular1045173cellular
censual937663censu_al
censurer10228133censurer
cingula10327173cingula_
circular1247913circular
coagula1045413coagula_
coinsurer1144773coinsurer
collar83816173co__llar
conciliar1345923conciliar
concur10411103concu__r
condoler113412123condoler
conducer13127373conducer
confuter1338513confuter
conjugal1843513conjugal
conjurer17117683conjurer
conjuror17144633conjuror
conquer1838623conqu_er
conquian1945733conquian
consider11310393consider
consol82614113consol__
console92715983consol_e
consoled112911453consoled
consolers112510923consolers
consoles103216153consoles
consols92914073consol_s
consulates12711103consulates
consultant1246703consultant
consulted1277923consulted
consulters1297213consulters
consultors1286403consultors
consume11510133consu_me
consumed1337923consumed
consumers1337203consumers
consumes12310413consumes
convulse1345443convulse
copula102812053co_pula_
copulae112810623co_pulae
copulas113811573co_pulas
coruler9311713co_ruler
costar85518613co_s_tar
cougar958783co__ugar
counselor1143543counselor
cupular11317633c_upular
grossular1042773grossular
insulars8137323_insulars
jocular1637313jo_cular
lingular9407503lingular
lobular936673lo_bular
locular938963lo_cular
lunular736023lun_ular
modular1087363mo_dular
monocular1345813monocular
monovular1443303monovular
morular978223mo_rular
nodular876703no_dular
nonpolar1046283nonpolar
nonsugars1043703nonsugars
ocular8610143_o_cular
oscular937943_oscular
ovular946833_o_vular
pendular1144943pendular
pinnular1044433pinnular
popular11319573po_pular
proconsular1561783proconsular
ranular739443ran_ular
singular9327573singular
tissular843823tissular
tonsillar943843tonsillar
undular837133_undular
ungular836783_ungular
venular1037683ven_ular
zonula1537223zon_ula_
zonulae1645963zon_ulae
zonulas1637023zon_ulas

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.420425454.8
2DLD Change Limit1461621057.01620832.7
3Display Results1051050.0462282.6
 (SQL Overall)1786911057.48223882.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.