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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

115 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
confabulating2110272(None) 
confabulation2063302confabulation
confabulations2162802confabulations
coagulating1545073co__agulating
confabulate1853663confabulat__e
confabulated2073123confabulat_ed
confabulates1953493confabulat_es
confabulator19142713confabulat_or
confabulators20142543confabulators
confabulatory23122273confabulatory
conflating16410003conf___lating
congratulating1862143congratulating
fabulating1645513___fabulating
cannulating1446004can__nulating
canulating1349544c___anulating
collaborating1852584collaborating
concatenating1853264concatenating
confabbing2042504confab___bing
confederating2054014confederating
confiscating2053614conf_iscating
confuting1539094conf__u__ting
conjugating2244504con__jugating
constellating1653264constellating
consulting1349084con__sul_ting
contaminating1854914contaminating
contemplating2054124contemplating
copulating1549374co___pulating
infatuating1543584_infatu_ating
somnambulating2191524somnambulating
tabulating1346414___tabulating
ablating11311995____ab_lating
adulating1178715____adulating
ambulating1546355___ambulating
angulating1247815_an__gulating
calculating1666785c__alculating
cantillating1565045can_tillating
capitulating1773965c_apitulating
catapulting1651745c_atapul_ting
circulating1647735c__irculating
coagulation1447275co__agulation
coagulations1546515co__agulations
coequating2245325co__equ_ating
cohabiting1844805co_hab__iting
cohobating1845025co_hob__ating
collating12312765co____llating
combating16310155co__mb__ating
combusting1745445co__mbu_sting
commutating1846025co__mmutating
concentrating1856435concentrating
conciliating1775615con_ciliating
conducting1648835con__du_cting
confecting18310555conf___ecting
configuration1954135configuration
configurations2063705configurations
configurative2262815configurative
configuring1853155configu__ring
conflation15412085conf___lation
conflations16411145conf___lations
conflicting1944725conf__licting
confounding1843265conf_ou_nding
confronting1744865conf__ronting
confusing1537335conf__u__sing
confutation1668725conf__utation
confutations1767795conf__utations
confutative1955445conf__utative
conglobating1853165con_globating
congratulation1782825congratulation
congratulations1882785congratulations
congregating1754285con_gregating
consecrating1747945con_secrating
consociating1755575con_sociating
consolidating1753285consolidating
constabularies18131125constabularies
consternating1654975consternating
constipating1775395con_stipating
constructing1746755constru_cting
consummating1953665con_summating
contacting15610075conta___cting
contributing1754305contribu__ting
convoluting1744205con__voluting
convulsing1645385con__vul_sing
corelating13511585co___relating
correlating1487085co__rrelating
corroborating1862435corroborating
corrugating1544265co__rrugating
cumulating1546355c___umulating
defaulting1543395_defa_ul_ting
ejaculating2144825__ejaculating
encapsulating1852195_encapsulating
faulting12237735___fa_ul_ting
footfaulting195735footfa_ul_ting
formulating1765045fo__rmulating
granulating1345295__granulating
gratulating1344725__gratulating
inflating13310445_inf___lating
inoculating1446725_in_oculating
inosculating1553815_inosculating
insulating1139265_in__sulating
jaculating2047295___jaculating
maculating1549545___maculating
manipulating1753745man_ipulating
modulating1446375mo___dulating
noncirculating1961755noncirculating
obnubilating1751505_obnubilating
osculating1347375_o__sculating
ovulating1336955_o___vulating
oxalating1745805_o_xa__lating
perambulating2052515perambulating
populating1547665po___pulating
postulating1447505po__stulating
tribulating1445345__tribulating
tubulating1345585___tubulating
unabating1246755_un_ab__ating
uncalculating1851955_uncalculating
undulating1247145_un__dulating

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 Filter1786911247900.1401276364.3
2DLD Change Limit1247901158.23315157.3
3Display Results1151150.0801437.5
 (SQL Overall)1786911158.45321139.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.