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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

146 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
brome9442197(None) 
biome94916991biome
broke116019781broke
bromes104719761bromes
bromo95217201bromo
brose75227031brose
brume95817981brume
arame75026622arame
aroma71220142aroma
arose55832082arose
become123312592become
berime105317332berime
berme96022942berme
biomes103815252biomes
bireme10310142bireme
blame95625492blame
bloke114316632bloke
blume95619892blume
bode75838752b_ode
bole66448692b_ole
bomb106927422b_omb
bombe115519312b_ombe
bone65949322b_one
boom87435672boom_
boomed115318132boomed
boomer104618512boomer
booms95427122booms
boomy125421822boomy
booze164718912booze
bore66051332b_ore
borne77926792borne
brace95629272brace
brae65639112br_ae
brake116025342brake
brave104925502brave
braze165423452braze
brede85520502brede
bree67241262br_ee
breve105317052breve
bribe94820782bribe
bride86425532bride
brie65837902br_ie
brim85629372brim_
brims94721622brims
brine75132272brine
bro56236602bro__
broad84817692broad
broche133612102broche
brock136017072brock
brogue94211032brogue
broil74918222broil
broken124011522broken
broker124314242broker
bromal10313652bromal
bromate11313552bromate
bromic122412692bromic
bromid112612892bromid
bromide12269582bromide
bromin102615692bromin
bromine112915242bromine
bromize20238822bromize
bromos104213312bromos
bronc91714342bronc
bronze173610922bronze
broo65129822bro_o
brood84620242brood
brook114717762brook
broom95022212broom
broomed124111052broomed
brooms104915872brooms
broomy13449952broomy
broos75126412broos
bros65635662bro_s
broses86524402broses
brosy106115382brosy
broth106521092broth
brow97228442bro_w
browed125216392browed
brown105619532brown
brows105425982brows
browse115713852browse
brumes106417072brumes
brute75321782brute
chrome133214812chrome
come87547702_come
creme94319322creme
crime94822692crime
crone75231332crone
crore74922872crore
croze164719452croze
dome77240732_dome
drone65324982drone
drove95518062drove
erode64520992erode
erose55727272erose
forme105225992forme
frame105821802frame
froe75329992fro_e
from96923922from_
frore86218802frore
froze174515652froze
gnome84213952gnome
grime85021322grime
grope84821612grope
grove95219332grove
grume86218162grume
home98042442_home
irone55126362irone
krone94018732krone
mome85239352_mome
nome66038422_nome
pome85636692_pome
prime96525602prime
probe94320812probe
proem94818272proem
prole74527792prole
prom87631702prom_
promo95620002promo
proms95426412proms
prone75332622prone
prose75835122prose
prove104823192prove
rime65138882_rime
robe65335642_robe
rode55844302_rode
roe36861082_ro_e
role45851822_role
rom59855632_rom_
romeo73719702_romeo
romp85926572_romp
roms67038962_roms
rope65542912_rope
rose46148902_rose
rote46249022_rote
roue45941742_roue
rove75136982_rove
some66040382_some
tome67543192_tome
trode65322852trode
troke94821052troke
tromp95815802tromp
trompe105611262trompe
trone55131862trone
trope75725802trope
trove85221922trove
wrote84717482wrote

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 Filter178691538000.300595636.7
2DLD Change Limit538001461.65332546.9
3Display Results1461460.0334424.2
 (SQL Overall)1786911461.98689975.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.