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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

52 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
circumlocutions2072051circumlocutions_
circumlocution1972242circumlocution__
circumvolutions2472453circumvolutions_
circumlocutory2291264circumlocut_o_ry
circumvolution2372764circumvolution__
circulations1648485circu_l__ations_
circumcisions1883055circum__cisions_
circumfusions2262975circum__fusions_
circumspections2272255circumspections_
circumventions2362945circum_ventions_
circulation1549396circu_l__ation__
circumcision1783296circum__cision__
circumfusion2163176circum__fusion__
circumspection2172556circumspection__
circumvention2263256circum_vention__
inculcations1666316_incu_l_cations_
allocutions1353987____allocutions_
bilocations1545297bi____locations_
calculations1647077calcu_l__ations_
circularities1755037circu_lariti_es_
circulating1647737circu_l__ati_n_g
circulators1545737circu_l__at_ors_
circumcise1583867circum__c__i__se
circumcises1683937circum__c__ises_
circumcising1863267circum__cisi_n_g
circumfluous2161927circum_flu__ous_
circumfusing2272797circum__fusi_n_g
circumlunar1762397circuml__u___nar
circumscribes2062977circum_sc_ribes_
circumscription2282267circumscription__
circumvallation2482417circumvallation__
circumventing2362867circum_venti_n_g
collocations1646407___collocations_
concoctions1448257conc___oc_tions_
coruscations1645247cor_u__scations_
discolorations17104307disc_olorations_
dislocations15136987di___slocations_
echolocations2052627__echolocations_
electrocutions1863017elec_trocutions_
elocutions1245967_____elocutions_
inculcation1557247_incu_l_cation__
inculpations1675967_incu_l_pations_
irresolutions13162377_ir_resolutions_
locutions11207067______locutions_
microevolutions2282337microevolutions_
misallocations1853097mi_sallocations_
mislocations16145657mi___slocations_
reallocations1553807__reallocations_
recirculations1884227recircu_l__ations_
relocations13311147__r__elocations_
translocations1664237_translocations_
uncircumcisions2081277uncircum__cisions_

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 Filter178691950240.360496363.9
2DLD Change Limit95024527.94011967.8
3Display Results52520.0461130.4
 (SQL Overall)178691528.34621410.4
 
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.