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

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

152 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
bromating143918(None) 
abrogating1497982abrogating
bloating113512812blo_ating
boating103721302b_o_ating
borating113414502b_orating
brocading1556252brocading
brominating1696092brominating
bromizing2346582bromizing
cremating14312202cremating
probating14311192probating
promoting1439922promoting
prompting1637202prompting
pronating12313762pronating
prorating12314282prorating
remating112322422_remating
rotating92614552_rotating
animating12312513animating
arointing1049363arointing
aromatic12315643aromati_c
aromatics13410903aromatics
aromatize20410303aromatize
aromatizing2346633aromatizing
aroynting1344633aroynting
arrogating121778393arrogating
automating1389303automating
bating95132253b___ating
beating104326873b__eating
bemoaning1435953bemoaning
berating113220763b_erating
bevomiting1843103bevomiting
bleating113514503b_leating
blotting113910433blo_tting
bloviating1643813bloviating
boasting113512503b_oasting
boatings113710113b_o_atings
bogarting1334653b_ogarting
bolting104416763b_o_lting
bombing143211393b_om_bing
bookmaking1843133bookmaking
booming123716223boom__ing
boosting113311053b_oosting
booting103821363b_o_oting
bracing123817613br__acing
braking143917713br__aking
brambling1635543brambling
braving133714613br__aving
braying134416313br__aying
brazing193715113br__azing
breading123515463br_eading
breaking153914253br_eaking
breaming133612513br_eaming
breasting1239583breasting
breathing15218373br_eathing
breveting1536263breveting
brigading1445143brigading
brimming15196623brim_ming
broaching17287663broaching
broiling113112013bro_iling
brokering1636283brokering
broking143514823bro__king
bromate11313553bromat__e
bromated1339173bromat_ed
bromates12413143bromat_es
bromelin1246343bromelin_
bromelins1346463bromelins
bromin102615693brom__in_
bromine112915243brom__ine
bromins112513783brom__ins
bronzing2037693bro_nzing
brooding122911373bro_oding
brooking153710703bro_oking
brooming132911143bro_oming
browbeating1952363browbeating
browning14299643bro_wning
browsing14319353bro_wsing
bruiting11259973br_uiting
bruting102612993br__uting
chromatin16410753chromatin_
chromatins1749123chromatins
coating103525313_co_ating
comaking1739993_comaking
combating16310163_combating
compting153013603_compting
coronating13410173coronating
corotating1349323corotating
crating103725203cr__ating
creating113921953cr_eating
croaking153712163cro_aking
derogating1348633derogating
doating93816863_do_ating
donating10311803_donating
embrocating1844143embrocating
floating123111883flo_ating
formatting1644163formatting
fronting12310443fro_nting
frosting12311183fro_sting
frowsting1634683frowsting
gemmating1576443gemmating
gloating102611463glo_ating
gradating1237323gradating
grating93923183gr__ating
grimacing1544033grimacing
groaning102410283gro_aning
grommeting1642913grommeting
grouting103410793gro_uting
homaging1536613_homaging
iodating1038823_iodating
isolating1039743isolating
locating11311503_locating
mating94832913___mating
mismating141211823mismating
moating104218153_mo_ating
notating92513343_notating
orating83520323__orating
ozonating1944323ozonating
perorating13313133perorating
phonating1537813phonating
pomading1437423_pomading
prating103424453pr__ating
predating13514653predating
profaning1537293profaning
profiting1549983profiting
promising14410973promising
promoing13310463prom_oing
rating74938703_r__ating
rebating112418343_rebating
redating102620173_redating
relating92725443_relating
remaking152613303_remaking
roaming103215793_ro_aming
roaring82916003_ro_aring
roasting93012703_roasting
romaine9512123_roma_ine
romancing1446043_romancing
romping123113033_rom_ping
roosting93411463_roosting
rooting83522433_ro_oting
rotting82919683_ro_tting
rousting93913273_rousting
routing83821093_ro_uting
solating9315593_solating
subrogating15164983subrogating
summating1437943summating
throating1398403thro_ating
treating92519613tr_eating
troaking133310973tro_aking
tromping13319603trom_ping
trotting92510913tro_tting
urinating10310653urinating
violating1337443violating
vomiting1437733_vomiting
womaning1437643_womaning

Search took 8 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 Filter1786911486410.436409841.7
2DLD Change Limit1486411526.92321470.6
3Display Results1521520.0762000.0
 (SQL Overall)1786911527.43524033.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.