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

67 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
bromos10421331(None) 
bromes104719761bromes
bromo95217201bromo_
brooms104915871brooms
broos75126411bro_os
promos105116421promos
aromas81018612aromas
biomes103815252biomes
blooms104613172blooms
bohos105618252b_ohos
bolos75531372b_olos
bombs115818822b_ombs
booms95427122boom_s
boos67955032b_o_os
boyos105418282b_oyos
bozos165216862b_ozos
bravos114711392bravos
brims94721622brim_s
brios74725722br_ios
broads94515152broads
brocks145214152brocks
broils84114172broils
bromal10313652bromal
bromals1139742bromals
brome94421972brom_e
bromic122412692bromic
bromid112612892bromid
bromids12278602bromids
bromin102615692bromin
bromins112513782bromins
bromism1337622bromism
broncos11188072broncos
broncs101611152broncs
broo65129822bro_o_
brood84620242bro_od
broods95416382broods
brook114717762bro_ok
brooks125813882brooks
broom95022212bro_om
broomy13449952broomy
bros65635662br__os
broses86524402broses
broths115013922broths
browns116415632browns
brows105425982bro_ws
brumes106417072brumes
brumous11107442brumous
chromos142610272chromos
dromon939362dromon
dromons1038192dromons
duomos936822duomos
grooms94512522grooms
homos105921792_homos
irokos1037232irokos
nomos75919742_nomos
pomos95321582_pomos
primos104514422primos
promo95620002promo_
proms95426412prom_s
prosos85718552prosos
romeos84013172_romeos
romps94617542_romps
roms67038962_rom_s
rooms75324682_rooms
rotos56027882_rotos
tromps104911702tromps
vrooms11398712vrooms

Search took 3 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 Filter178691825510.360496363.9
2DLD Change Limit82551672.37334787.6
3Display Results67670.0332030.3
 (SQL Overall)178691672.76664602.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.