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

76 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
brooklet145640(None) 
booklet132312641b_ooklet
brooklets1543681brooklets
booklets14247122b_ooklets
boomlet112412272b_oomlet
brocket154013382brock_et
brooked143610032brook_ed
brookie1347372brookie_
brookies1459142brookies
brookite1445502brookite
hooklet142510812_hooklet
rootlet73015732_rootlet
bomblet13412263b_omblet
boodle93215033b_oodle_
boodled113410933b_oodled
boodler103312003b_oodler
boodles103416043b_oodles
booked135319503b_ook_ed
booker124719193b_ook_er
bookie123516003b_ookie_
bookies133819403b_ookies
bookmen15126263b_ookmen
bookrest1436493b_ookrest
boomlets12246673b_oomlets
bootleg10276633b_ootleg
bosket124919223b_osk_et
bracelet12310693bracelet
bracket154117233brack_et
bractlet1239283bractlet
brickle15279933brickle_
brickles162810283brickles
brisket134413403brisk_et
brockets16328123brock_ets
broiled103811423br_oiled
broiler92911753br_oiler
broke116019783br_ok_e_
broken124011523br_ok_en
broker124314243br_ok_er
brooches15288193brooches
brooded113510933broo_ded
brooder103811623broo_der
broodier1157433broodier
broodiest1237823broodiest
broodless1235033broodless
brook114717763brook___
brooking153710703brooking
brookites1545033brookites
brooklike1453273brooklike
brooklime1752353brooklime
brooklimes1841903brooklimes
brooks125813883brook__s
broomed124111053broo_med
broomier1236873broomier
broomiest1356913broomiest
crocket154615673crock_et
crooked143910943crook_ed
crooker134111093crook_er
crookest1436683crookest
crosslet1049593crosslet
drooled9369203droo_led
droplet10312113dr_oplet
froglet11310063fr_oglet
frontlet1147653frontlet
hooklets15217203_hooklets
moonlet92413273_moonlet
rocket125425283_rock_et
rooked114918143_rook_ed
rookie103613263_rookie_
rookier114012383_rookier
rookies113917103_rookies
rookiest122912173_rookiest
rootle63214453_rootle_
rootled83410533_rootled
rootles73215633_rootles
rootlets8308653_rootlets
triolet73219523trio_let

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 Filter1786911461620.1531167915.0
2DLD Change Limit146162768.23617746.7
3Display Results76760.0461652.2
 (SQL Overall)178691768.43521184.5
 
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.