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

54 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
caricatured167255(None) 
caricature1474041caricature_
caricatures1564001caricatures
caricatural1552782caricatural
arcature1086503_ar_cature_
arcatures1186853_ar_catures
armatured1264623_ar_matured
caricaturing1752303caricaturing
caricaturist1663533caricaturist
carinated123414273carinat__ed
armature10106974_ar_mature_
armatures1166984_ar_matures
cacciatore1353404cacciatore_
candidature1551514candidature_
candidatures1651624candidatures
capitated14159044capitat__ed
captured1336574ca___ptured
caricaturists1762644caricaturists
carinate103320254carinat__e_
carpentered1652494carpentered
cavitated15177354cavitat__ed
charactered1952884charac_tered
cinctured1444274c__inctured
cofeatured1642714c_ofeatured
cratered1149684c_r__atered
creature1038744c_r_eature_
creatures1138424c_r_eatures
crenature1145764c_renature_
crenatures1245344c_renatures
curvature1442794cur_vature_
curvatures1542774cur_vatures
fabricated1845404fabricat__ed
fractured15125064_frac_tured
judicature2052364judicature_
judicatures2151924judicatures
lariated91212064lari_at__ed
ligatured1143334__ligatured
loricated1247894loricat__ed
manicured1443734manic__ured
mariculture1554684mariculture_
maricultures1654914maricultures
marinated122513174marinat__ed
muricated1448244muricat__ed
pictured1346574__pic_tured
plicature1344024_plicature_
plicatures1443984_plicatures
radicated13410124radicat__ed
recaptured1573594__recaptured
renatured1047294__renatured
stricture1145904stric_ture_
strictures1246174stric_tures
structured1343994struc_tured
variated121211394vari_at__ed
varicolored1751544varicolored

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 Filter1786911488190.466383457.1
2DLD Change Limit148819549.08016389.8
3Display Results54540.0163375.0
 (SQL Overall)178691549.56218687.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.