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

62 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
brocoli114635(None) 
broccoli1443551broccoli
brocolis1247301brocolis
bricole112810492bricole
broccolis1543802broccolis
biosolid1144893biosolid
bocci113512713b_oc_ci
boocoo1039003booco_o
boocoos1137753boocoos
borecole1246623borecole
borzoi1736623borzo_i
braciola1245273braciola
braciole1246973braciole
braconid1345633braconid
brickle15279933brickle
bricoles122610303bricoles
broadly1337153broadly
brocade1238533brocade
broche133612103broc_he
brock136017073broc__k
brocket154013383brocket
brocks145214153broc_ks
broil74918223bro_il_
broils84114173bro_ils
brolly114510853bro_lly
bromal10313653bromal_
bromals1139743bromals
bromelin1246343bromelin
bromo95217203bromo__
bromos104213313bromo_s
bronchi14176313bronchi
bronco10179493bronco__
broncos11188073bronco_s
broo65129823bro_o__
brooch13368443bro_och
brood84620243bro_o_d
broods95416383bro_ods
broody124510083bro_ody
brook114717763bro_o_k
brookie1347373bro_okie
brooks125813883bro_oks
broom95022213bro_o_m
brooms104915873bro_oms
broomy13449953bro_omy
broos75126413bro_o_s
bucolic1345593b_ucolic
croci95818133croc__i
drool65416103dro_ol_
drools74412813dro_ols
drooly104911073dro_oly
krooni10397183kro_oni
loculi8288253_loculi
oboli73712873__oboli
oculi72010793__oculi
ovoli8358283__ovoli
propolis12311403propolis
recoil84016723_recoil
rococo1036813_rococo
rosolio746983_rosolio
tripoli937133tripoli
trochil1258713trochil
trochili1376943trochili

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 Filter1786911340270.406440125.6
2DLD Change Limit134027626.36021073.4
3Display Results62620.0163875.0
 (SQL Overall)178691626.78226347.8
 
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.