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

42 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
circumvallation248241(None) 
circumvallating2571982circumvallating
circumvallate2292573circumvallat__e
circumvallated2482233circumvallat_ed
circumvallates2372433circumvallat_es
circumvolution2372763circumv_olution
circulation1549394circu____lation
circumvention2263254circumv__ention
circumvolutions2472454circumv_olutions
circularization2873175circularization
circulations1648485circu____lations
circumlocution1972245circum_locution
circumscription2282265circumscription
circumspection2172555circum_spection
circumventions2362945circumv__entions
accumulation18153806_accum__ulation
calculation1548296calcu____lation
cancellation1655016canc___ellation
circulating1647736circu____lating
circulative1855566circu____lative
circulator1446146circu____lat_or
circumcision1783296circum___cision
circumfusion2163176circum___fusion
circumlocutions2072056circum_locutions
circumnavigator2591696circumnavigat_or
circumspections2272256circum_spections
circumventing2362866circumv__enting
compellation1855106___compellation
crenellation1453916c_r__enellation
cumulation1448176___cum__ulation
cupellation1544146___cu_pellation
inculcation1557246_incu___lcation
inculpation1546776_incu___lpation
incurvation1646986_incurv___ation
installation1254916_i__nstallation
misevaluation18153626mi__sevaluation
predevaluation2062386_predevaluation
recirculation1764906recircu____lation
reevaluation1554486__r_eevaluation
revaluation1458146__r__evaluation
transvaluation1763366_transvaluation
vallation1239756______vallation

Search took 7 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.356501941.0
2DLD Change Limit95024426.58014441.3
3Display Results42420.0301400.0
 (SQL Overall)178691426.96625651.9
 
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.