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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

43 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
broiders11421118(None) 
braiders114110571braiders
broider103912971broider_
broidery14356081broidery
broilers103210091broilers
brooders112610231brooders
avoiders1254782avoiders
biders94822802b__iders
boilers93417062b_oilers
bonders104120662b_onders
borders104317532b_orders
borides10515152boride_s
braider105112992braider_
branders114313092branders
breeders11368892breeders
bribers114111492br_ibers
brides94423512br_ide_s
bridlers11359182br_idlers
briers85319732br_i_ers
briners94315632br_iners
broadens11267232broadens
broader103412602broader_
broidered1344932broidered
broiderer1244352broiderer
broiderers1343222broiderers
broideries1346342broideries
broiler92911752broiler_
brokers133111912bro_kers
bromides13219362bromide_s
bronzers19296982bronzers
brooder103811622brooder_
brothers133410822brothers
browsers13449192browsers
bruisers10307952bruisers
bruiters10329132bruiters
crowders14398792crowders
embroiders1543512embroiders
oroides8311972oroide_s
prodders1237452prodders
providers1535582providers
raiders84615142_raiders
riders74123902_r_iders
voiders11279822_voiders

Search took 7 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 Filter1786911210590.220812231.8
2DLD Change Limit121059436.29619227.9
3Display Results43430.0331303.0
 (SQL Overall)178691436.54927285.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.