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

60 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
circumspections227225(None) 
circumspection2172551circumspection_
circumventions2362943circum_ventions
circumlocutions2072054circumlocutions
circumspect1862674circumspect____
circumspectly2371884circumspect__ly
circumvention2263254circum_vention_
circumvolutions2472454circumvolutions
circulations1648485circu___lations
circumcisions1883055circum__cisions
circumfusions2262975circum__fusions
circumlocution1972245circumlocution_
circumscribes2062975circums__cribes
circumscription2282265circumscription_
circumventing2362865circum_venti_ng
circumvolution2372765circumvolution_
inspections1546425_i___nspections
introspections1864065_introspections
reinspections1753095__reinspections
bisections14136736bi____s_ections
carburetions1652386carbu__re_tions
circulation1549396circu___lation_
circumcenters1862656circum_cent_ers
circumcises1683936circum___c_ises
circumcision1783296circum__cision_
circumfusion2163176circum__fusion_
circumscribe1973006circums__cri_be
circumscribed2172616circums__cribed
circumscribing22122226circums__cribing
circumstantial2072186circumstanti_al
circumstantiate2182146circumstantiate
circumvallation2482416circumvallation_
circumvents2053696circum_vent___s
compactions1946546___com_pactions
consumptions1845146consum_p__tions
corrections1548866cor____rections
corruptions1555176corru__p__tions
coruscations1645246cor_u_s_cations
directions1379646dir_____ections
disconnections1954026disc_onnections
dissections14198266di____ssections
haruspications2151626har_u_spications
impactions1645416_i___m_pactions
inculpations1675966_incu_lp_ations
inspection1446666_i___nspection_
insurrections15104146_insu_rrections
intersections1598966_inters_ections
introspection1764626_introspection_
irruptions1243896_irru__p__tions
microinjections2862426microinjections
midsections1644406mi___ds_ections
misconnections2063816misc_onnections
reinspection1653266__reinspection_
resections121513036__r__es_ections
retrospections1894176_retrospections
subsections1597106___subs_ections
transections1446766_tr_ans_ections
transfections1854856_tr_ansfections
trisections1345646_tr__is_ections
vivisections2052716vi__vis_ections

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 Filter178691950240.376475242.0
2DLD Change Limit95024606.81013953.6
3Display Results60600.0501200.0
 (SQL Overall)178691607.23624694.7
 
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.