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

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
circumferences227209(None) 
circumference2162401circumference_
circumferential24161744circumferential
circumflexes2882104circumf_le_xes
circumstances1862294circum_stances
circumcenter1763315circum__center
circumcenters1862655circum__centers
circumcircles1772125circumcir_cles
circumfluent2162635circumfluen__t
circumfuses20103375circumf___uses
circumscribes2062975circumscr_ibes
circumstance1762625circum_stance_
circumstanced1971835circum_stanced
circumvented2263215circum__vented
circumvents2053695circum__ven_ts
concurrences1554405concu__rrences
conferences1898815___conferences
differences2054915di___fferences
incoherences1954905_inc_oherences
incompetences21154525_incompetences
incurrences1555335_incu__rrences
indifferences2262815_indifferences
inferences15410345_i___nferences
interferences1855475_interferences
irreverences1752925_ir_reverences
misreferences20102095mi_sreferences
preferences1876185_pr__eferences
references1589355__r__eferences
transferences1853685_transferences
cicerones1347076ci_c___eron_es
circuitries1553886circu_itr__ies
circularises16125556circu_lar_ises
circularities1755036circu_larities
circularizes25145016circu_lar_izes
circularness1662126circu_lar_ness
circularnesses1861416circularnesses
circumcircle1662286circumcir__cle
circumcisers1782756circumcise__rs
circumcises1683936circum___cises
circumflex2652266circumf____lex
circumfluous2161926circumf__luous
circumfuse19113046circumf___use_
circumfused21122746circumf___used
circumfusing2272796circumfusin__g
circumfusions2262976circumf_usions
circumjacent2462716circumjacen__t
circumscribe1973006circumscr_ibe_
circumscribed2172616circumscr_ibed
circumspect1862676circum_spe_c_t
circumvallates2372436circumvallates
circumvent1954046circum__ven__t
circumventions2362946circumventions
coherences1787046___c_oherences
competences1956376___competences
concupiscences18161716concupiscences
concurrence1454796concu__rrence_
concurrencies1653166concu__rrencies
conference1799006___conference_
conferrences19106076___conferrences
corpulences1754036corpu___lences
credences1498146c_r____edences
cumbrances1844216___cum_brances
deferences1677876____deferences
difference1955026di___fference_
differenced2153466di___fferenced
encumbrances20152046_encum_brances
incoherence1855186_inc_oherence_
incompetence20115126_incompetence_
incompetencies2263416_incompetencies
incumbencies2053176_incum__bencies
incurrence1455736_incu__rrence_
indifference2162906_indifference_
indifferencies2362486_indifferencies
inference14411026_i___nference_
inherences1568966_i___nherences
intemperances1953146_intemperances
interference1756006_interference_
intumescences1983666_intumescences
irreverence1653106_ir_reverence_
misreference1982526mi_sreference_
nonconference2074196nonconference_
occurrences1452776_occu__rrences
preference1776986_pr__eference_
recurrences1544866_recu__rrences
reemergences1753046__reem_ergences
reference14810096__r__eference_
referenced1676866__r__eferenced
reverences1579176__r__everences
sufferances1953376___sufferances
teleconferences227976teleconferences
transference1754316_transference_
vicegerencies2161216vi_c_egerencies
virulences1543856vir_u___lences

Search took 10 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 Filter1786911247900.1401276364.3
2DLD Change Limit124790939.62612963.8
3Display Results93930.0631476.2
 (SQL Overall)178691939.82918180.0
 
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.