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

43 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
confabulations216280(None) 
confabulation2063301confabulation_
confabulating21102722confabulati_ng
confabulators20142542confabulat_ors
coagulations1546513co__agulations
confabulates1953493confabulat__es
confabulator19142713confabulat_o_r
confabulatory23122273confabulat_ory
configurations2063703configurations
conflations16411143conf___lations
confutations1767793conf__utations
congratulations1882783congratulations
coagulation1447274co__agulation_
cohabitations2053454co_habitations
collaborations1872744collaborations
concatenations1873724concatenations
confabulate1853664confabulat___e
confabulated2073124confabulat__ed
confederations20104604confederations
configuration1954134configuration_
confirmations2055674conf_irmations
confiscations2044954conf_iscations
conflagrations2052724conflagrations
conflation15412084conf___lation_
conformations2046724conf_ormations
confrontations1962784confrontations
confutation1668724conf__utation_
congelations1549734con__gelations
congratulation1782824congratulation_
conjugations2245864con__jugations
conjurations2148494con__jurations
consolations1449734con__solations
constellations1654404constellations
consultations1546934con__sultations
contaminations1886104contaminations
contemplations2074734contemplations
continuations1547144continu_ations
conurbations1646664conurb__ations
copulations151111114co___pulations
infatuations1544434_infatu_ations
lobulations1346204lo___bulations
somnambulations2161434somnambulations
tabulations1346844___tabulations

Search took 4 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 Filter178691658740.1101624463.6
2DLD Change Limit65874433.56018503.9
3Display Results43430.0331303.0
 (SQL Overall)178691433.70348255.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.