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

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
continual114714(None) 
continua1047651continua_
continually1655082continually
continuant12128292continuant
continuate1248332continuate
continue10311122continu_e
continued1248482continued
continuer1148712continuer
continues11310992continues
continuo1047352continu_o
continuos1147002continuos
continuum1344132continuum
cantina93417253cantin_a_
cantinas102713783cantin_as
cantonal1038903canton_al
cochineal1643513cochineal
coitional1148693coitional
congenial1248813congenial
conical11316203con_i_cal
conidial1159503con_idial
conoidal1149013conoi_dal
consensual1253973consensual
construal1146793construal
contextual1954353contextual
continent11415633continent
continental1375653continental
continuance1555123continuance
continuants13125323continuants
continuator1386013continuator
continuers1247943continuers
continuing1348193continuing
continuity1545993continuity
continuous1245723continuous
continuums1453523continuums
conventual1546093conventual
convivial1764113convivial
cornual94210173co__rnual
cortical12412213corti_cal
cortina91915973cortin_a_
cortinas102212453cortin_as
cotidal1038463co_ti_dal
cotinga10348023co_tinga_
cotingas11316323co_tingas
dentinal939503dentin_al
fontina1038633fontin_a_
fontinas1136853fontin_as
nonfinal1147703nonfin_al
nonlineal946163nonlineal
nonmanual1144903nonmanual
nontidal948673nonti_dal
nontonal849743nonton_al
nonvisual1244003nonvisual

Search took 8 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 Filter1786911486410.423422437.4
2DLD Change Limit148641526.92321470.6
3Display Results52520.0134000.0
 (SQL Overall)178691527.35924282.0
 
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.