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

50 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
cretinous114589(None) 
chitinous1474992chitinous
cretinoid1244362cretinoid
cretins93216422cretin__s
criminous1375322criminous
resinous838502_resinous
retinols8419742_retinols
arenous7314183are__nous
captious122810573capti_ous
cautious103110233cauti_ous
ceruminous1443193ceruminous
coetaneous1254163coetaneous
continuos1147003continuos
continuous1245723continuous
creatines112814433creatin_es
creatins103617513creatin__s
creations112614543creati_ons
creditors1245873creditors
credulous1243753credulous
creminis12208253cremin_is
crestings12298043crestin_gs
cretics112911653creti__cs
cretin82917913cretin___
cretinism1347123cretinism
cretinisms1446713cretinisms
cretonnes1144723cretonnes
glutinous1044463glutinous
heinous1038853_he_inous
keratinous1443573keratinous
mutinous1047653_mutinous
pectinous1345553pectinous
platinous1146193platinous
precious12310593preci_ous
previous1337823previ_ous
retinals85612963_retinals
retinas74819353_retin_as
retines75134673_retin_es
retinoid947353_retinoid
retinoids1045383_retinoids
retinol7469693_retino_l
retints74717013_retin_ts
retinue75414843_retin_ue
retinues85113153_retinues
rosinous847373_rosinous
ruinous739763_r_uinous
serotinous1044843serotinous
tretinoin943283tretinoin
tretinoins1043083tretinoins
urinous7310083ur__inous
verminous1445573verminous

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 Filter1786911486410.420425454.8
2DLD Change Limit148641507.84618944.8
3Display Results50500.0133846.2
 (SQL Overall)178691508.27921583.6
 
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.