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

36 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
bricklike164311(None) 
brickle15279932brickl__e
brooklike1453272brooklike
rocklike1335902_rocklike
sticklike1444002sticklike
beaklike13155773b_eaklike
biblike1536893b_i_blike
birdlike1535233b_irdlike
brickier16307163brick_ier
bricking173911403brick_ing
brickkiln1651323brickkiln
bricklayer2151723bricklayer
brickles162810283brickl_es
bricolage1453153bricolage
bricole112810493bricol__e
brooklime1752353brooklime
clocklike1642823clocklike
cocklike1536733_cocklike
disklike12206743_disklike
epiclike1644143epic_like
icelike1337173__icelike
inklike1037033__inklike
necklike13104563_necklike
prickle153611013prickl__e
pricklier17245063pricklier
prickling1836533prickling
quicklime2641823quicklime
riblike1337333_ri_blike
ringlike1336243_ringlike
sacklike1337303_sacklike
silklike1135523_silklike
trickie132611033trick_i_e
trickle133613443trickl__e
tricklier15256823tricklier
trickling1647723trickling
truckline1544913truckline

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 Limit148641367.08020994.5
3Display Results36360.0132769.2
 (SQL Overall)178691367.51623774.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.