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

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
confabulated207312(None) 
confabulate1853661confabulate_
confabulates1953491confabulates
confabulator19142712confabulator
coagulated1496533co__agulated
confabulating21102723confabulating
confabulation2063303confabulation
confabulators20142543confabulators
confabulatory23122273confabulatory
conflated1539333conf___lated
congratulated17112873congratulated
fabulated1546323___fabulated
cannulated1346504can__nulated
canulated12310674c___anulated
coagulate1258084co__agulate_
coagulates13137454co__agulates
collaborated1772814collaborated
concatenated1753524concatenated
confabbed1942464confab___bed
confabulations2162804confabulations
confederated1953994confederated
confiscated1953374conf_iscated
conflate13311174conf___late_
conflates14311134conf___lates
confuted1437684conf__u__ted
congratulate1583194congratulate_
congratulates16103294congratulates
conjugated2144144con__jugated
constellated15113574constellated
consulate11612234con__sulate_
consulates12711104con__sulates
consulted1277924con__sul_ted
contaminated1755274contaminated
contemplated1954444contemplated
copulated142710484co___pulated
fabulate1339204___fabulate_
fabulates1447734___fabulates
infatuated1443924_infatu_ated
lobulated12106424lo___bulated
nonregulated1453454nonregulated
somnambulated20122024somnambulated
tabulated1237304___tabulated

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.390458182.1
2DLD Change Limit124790429.04613795.0
3Display Results42420.0162625.0
 (SQL Overall)178691429.45218905.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.