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

91 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
broil7491822(None) 
boil66335181b_oil
brail75525551brail
broils84114171broils
roil46235291_roil
aboil72217542aboil
argil65116882argil
aril45843022ar_il
aroid65428342aroid
bail65042802b_ail
basil75122272basil
bezil163812882bezil
boils75427192b_oils
boll65634752b_oll
boral75831702boral
boric98024222boric
bowl96827702b_owl
braid85822262braid
brails84621292brails
brain76229382brain
brasil8713862brasil
brawl106217962brawl
brazil1779622brazil
brie65837902br_ie
brig76528032br_ig
brill74819952brill
brim85629372br_im
brin67038192br_in
brio65432492br_io
brios74725722brios
bris65539612br_is
brit66350152br_it
bro56236602bro__
broad84817692broad
brock136017072brock
broiled103811422broiled
broiler92911752broiler
broke116019782broke
brolly114510852brolly
bromal10313652bromal
brome94421972brome
bromic122412692bromic
bromid112612892bromid
bromin102615692bromin
bromo95217202bromo
bronc91714342bronc
broo65129822bro_o
brood84620242brood
brook114717762brook
broom95022212broom
broos75126412broos
bros65635662bro_s
brose75227032brose
brosy106115382brosy
broth106521092broth
brow97228442bro_w
brown105619532brown
brows105425982brows
bruin75818332bruin
bruit76126722bruit
coil66439652_coil
drail65020972drail
droid74218542droid
droit65127122droit
droll65415402droll
drool65416102drool
embroil1146612embroil
ervil8310302ervil
foil76433912_foil
frail85220212frail
grail64622872grail
groin65521082groin
growl96115822growl
moil65534092_moil
noil46133242_noil
oil37452052__oil
prowl105615122prowl
rail46147762_rail
reoil55321182reoil
roils54826792_roils
roily86121112_roily
roll46331652_roll
rotl45029682_rotl
soil46138832_soil
spoil75818652spoil
toil46536282_toil
trail55126772trail
triol55521362triol
trois57226092trois
troll54416532troll
zoril143916692zoril

Search took 2 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 Filter178691538000.313570897.8
2DLD Change Limit53800911.59333772.8
3Display Results91910.0332757.6
 (SQL Overall)178691911.93992156.3
 
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.